ELECTRICT COST HARPER 2026 .xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1												LOG SHEET ELECTRICAL CONSUMPTION COST
2												VERSION ENGINEERING ( POMEC )
3												PERIODE JANUARI 2023
4
5	DATE	LAST			PRESENT			CONSUMPTION			ELECTRICITY COST			TOTAL KWH		PPJ 5 %	DTD	TOTAL ELECTRYCITY	OCCUPANCY		COST /	REMARKS	EVENT /
6	DATE	LWBP	WBP	KVARH	LWBP	WBP	KVARH	LWBP	WBP	KVARH	LWBP	WBP	AMOUNT	METER	ACTUAL	PPJ 5 %	DTD	COST	ROOM	%	OCC ROOM	REMARKS	PAX
7	1	10474.357	2196.442	2008.9	10481.977	2197	2010.168	7.62	0.558	1.268	4,735,449	520,169	5,255,618	8.178	6,542	262,781		5,518,399	91	70.00	60,642
8	2	10481.977	2197	2010.168	10483.91	2198.322	2010.311	1.933	1.322	0.143	1,201,263	1,232,371	2,433,634	3.255	2,604	121,682		2,555,316	75	57.69	34,071
9	3	10483.91	2198.322	2010.311	10487.88	2199.154	2011.258	3.97	0.832	0.947	2,467,156	775,592	3,242,749	4.802	3,842	162,137		3,404,886	73	56.15	46,642
10	4	10487.88	2199.154	2011.258	10491.823	2200.009	2011.976	3.943	0.855	0.718	2,450,377	797,033	3,247,410	4.798	3,838	162,371		3,409,781	125	96.15	27,278
11	5	10491.823	2200.009	2011.976	10497.088	2201.089	2012.912	5.265	1.08	0.936	3,271,934	1,006,778	4,278,712	6.345	5,076	213,936		4,492,648	77	59.23	58,346
12	6	10497.088	2201.089	2012.912	10501.396	2201.989	2013.651	4.308	0.9	0.739	2,677,207	838,982	3,516,188	5.208	4,166	175,809		3,691,998	93	71.54	39,699
13	7	10501.396	2201.989	2013.651	10506.021	2203.125	2014.42	4.625	1.136	0.769	2,874,206	1,058,981	3,933,188	5.761	4,609	196,659		4,129,847	123	94.62	33,576
14	8	10506.021	2203.125	2014.42	10511.996	2204.264	2015.557	5.975	1.139	1.137	3,713,164	1,061,778	4,774,942	7.114	5,691	238,747		5,013,689	38	29.23	131,939
15	9	10511.996	2204.264	2015.557	10515.901	2205.025	2016.182	3.905	0.761	0.625	2,426,762	709,406	3,136,168	4.666	3,733	156,808		3,292,976	69	53.08	47,724
16	10	10515.901	2205.025	2016.182	10519.235	2205.874	2016.867	3.334	0.849	0.685	2,071,914	791,439	2,863,354	4.183	3,346	143,168		3,006,521	63	48.46	47,723
17	11	10519.235	2205.874	2016.867	10523.508	2206.698	2017.482	4.273	0.824	0.615	2,655,456	768,134	3,423,590	5.097	4,078	171,180		3,594,770	76	58.46	47,300
18	12	10523.508	2206.698	2017.482	10527.759	2207.556	2018.119	4.251	0.858	0.637	2,641,784	799,829	3,441,613	5.109	4,087	172,081		3,613,694	104	80.00	34,747
19	13	10527.759	2207.556	2018.119	10532.222	2208.625	2018.991	4.463	1.069	0.872	2,773,531	996,524	3,770,055	5.532	4,426	188,503		3,958,558	64	49.23	61,852
20	14	10532.222	2208.625	2018.991	10536.918	2209.512	2019.222	4.696	0.887	0.231	2,918,329	826,863	3,745,192	5.583	4,466	187,260		3,932,452	130	100.00	30,250
21	15	10536.918	2209.512	2019.222	10542.185	2210.808	2020.814	5.267	1.296	1.592	3,273,177	1,208,134	4,481,311	6.563	5,250	224,066		4,705,376	109	83.85	43,169
22	16	10542.185	2210.808	2020.814	10546.261	2211.711	2021.538	4.076	0.903	0.724	2,533,030	841,778	3,374,809	4.979	3,983	168,740		3,543,549	130	100.00	27,258
23	17	10546.261	2211.711	2021.538	10550.764	2212.713	2022.296	4.503	1.002	0.758	2,798,389	934,066	3,732,456	5.505	4,404	186,623		3,919,079	105	80.77	37,325
24	18	10550.764	2212.713	2022.296	10555.096	2213.743	2023.102	4.332	1.03	0.806	2,692,121	960,168	3,652,289	5.362	4,290	182,614		3,834,904	102	78.46	37,597
25	19	10555.096	2213.743	2023.102	10559.424	2214.645	2023.823	4.328	0.902	0.721	2,689,636	840,846	3,530,482	5.23	4,184	176,524		3,707,006	122	93.85	30,385
26	20	10559.424	2214.645	2023.823	10563.844	2215.728	2024.748	4.42	1.083	0.925	2,746,809	1,009,575	3,756,384	5.503	4,402	187,819		3,944,203	79	60.77	49,927
27	21	10563.844	2215.728	2024.748	10568.013	2216.696	2025.435	4.169	0.968	0.687	2,590,825	902,372	3,493,197	5.137	4,110	174,660		3,667,856	130	100.00	28,214
28	22	10568.013	2216.696	2025.435	10572.889	2217.865	2022.331	4.876	1.169	-3.104	3,030,190	1,089,744	4,119,934	6.045	4,836	205,997		4,325,931	86	66.15	50,302
29	23	10572.889	2217.865	2022.331	10578.013	2218.786	2027.317	5.124	0.921	4.986	3,184,310	858,558	4,042,868	6.045	4,836	202,143		4,245,011	62	47.69	68,468
30	24	10578.013	2218.786	2027.317	10582.202	2219.591	2027.996	4.189	0.805	0.679	2,603,254	750,423	3,353,677	4.994	3,995	167,684		3,521,360	79	60.77	44,574
31	25	10582.202	2219.591	2027.669	10586.348	2220.496	2028.752	4.146	0.905	1.083	2,576,532	843,643	3,420,175	5.051	4,041	171,009		3,591,183	116	89.23	30,958
32	26	10586.348	2220.496	2028.752	10590.882	2221.513	2029.488	4.534	1.017	0.736	2,817,654	948,049	3,765,704	5.551	4,441	188,285		3,953,989	103	79.23	38,388
33	27	10590.882	2221.513	2029.488	10595.111	2222.498	2030.228	4.229	0.985	0.74	2,628,112	918,219	3,546,331	5.214	4,171	177,317		3,723,648	56	43.08	66,494
34	28	10595.111	2222.498	2030.228	10598.896	2223.306	2030.856	3.785	0.808	0.628	2,352,188	753,219	3,105,407	4.593	3,674	155,270		3,260,678	68	52.31	47,951
35	29	10598.896	2223.306	2030.856	10602.389	2224.089	2031.466	3.493	0.783	0.61	2,170,725	729,914	2,900,639.02	4.28	3,420.80	145,031.95		3,045,670.97	34	26.15	89578.55785
36	30	10602.389	2224.089	2031.466	10606.3	2224.802	2032.207	3.911	0.713	0.741	2,430,491	664,660	3,095,150.98	4.62	3,699.20	154,757.55		3,249,908.52	84	64.62	38689.3872
37	31	10606.3	2224.802	2032.207	10610.007	2225.672	2032.776	3.707	0.87	0.569	2,303,715	811,016	3,114,731	4.577	3661.6	155736.5445		3,270,467	83	63.85	39403.2221
38								135.65	29.23	24.203	84,299,692	27,248,264	111,547,957	164.88	131,904	5,577,398		117,125,355	2749	68	47,435
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100