Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 TNB Excel Spreadsheet for new Domestic Tariff, Old, non-ToU & ToU + Single Cell Formula

views
     
TSsoonwai
post Sep 28 2025, 10:41 PM


********
All Stars
11,450 posts

Joined: Oct 2007
From: KL


October AFA published. Much higher discount than forecast. -6.5 sen/kWh.

This post has been edited by soonwai: Sep 28 2025, 10:47 PM
eyesee
post Oct 3 2025, 05:30 PM

Getting Started
**
Junior Member
186 posts

Joined: Jan 2009
QUOTE(soonwai @ Sep 28 2025, 10:41 PM)
October AFA published. Much higher discount than forecast. -6.5 sen/kWh.
*
Such high AFA rebate/discount is becoming unfair to those who are exempted from AFA.
To be fair, AFA rebate above a certain amount should be applied to ALL as this is due to lower fuel cost.

This post has been edited by eyesee: Oct 3 2025, 05:31 PM
TSsoonwai
post Oct 3 2025, 09:30 PM


********
All Stars
11,450 posts

Joined: Oct 2007
From: KL


QUOTE(eyesee @ Oct 3 2025, 05:30 PM)
Such high AFA rebate/discount is becoming unfair to those who are exempted from AFA.
To be fair, AFA rebate above a certain amount should be applied to ALL as this is due to lower fuel cost.
*
It's ok lah. Now -0.065, next time +0.065, will even out to 0.
eyesee
post Oct 4 2025, 02:44 PM

Getting Started
**
Junior Member
186 posts

Joined: Jan 2009
QUOTE(soonwai @ Oct 3 2025, 09:30 PM)
It's ok lah. Now -0.065, next time +0.065, will even out to 0.
*
I suppose it is ok if it is once a while the rebate is this high. If it iremains at this level or more for a few months, then those using 500-600kwh would feel "cheated" the most

They want to shield these low usage people from rising fuel cost but don't give them discount when they have lower fuel cost. What a contradiction..
TSsoonwai
post Oct 11 2025, 05:28 PM


********
All Stars
11,450 posts

Joined: Oct 2007
From: KL


So this month, I go micro manage the whole house punya TNB usage.

user posted image
2 more days to go. TNB bill forecast for this month: just above RM72.73

Always-on culprits.
1. SK Magic Water purifier Cold Water Tank
2. Ancient Aego M 2.1 speakers.
3. Back lane and front porch lights. Will probably have to live with this.
4. TPLink UH720 Powered USB hub

This post has been edited by soonwai: Oct 11 2025, 05:46 PM
zellleonhart
post Oct 12 2025, 12:05 AM

Stars stars stars
*******
Senior Member
5,075 posts

Joined: Oct 2008


Didn't know got someone did similar excel like me. Mine not as canggih but just for me to do rough estimation.

The energy dashboard web app is the worst shit ever. Most of the time it just keep spinning or redirecting to itself in an infinite loop. There's no reliable way to get the csv?
TSsoonwai
post Oct 12 2025, 12:23 AM


********
All Stars
11,450 posts

Joined: Oct 2007
From: KL


QUOTE(zellleonhart @ Oct 12 2025, 12:05 AM)
Didn't know got someone did similar excel like me. Mine not as canggih but just for me to do rough estimation.

The energy dashboard web app is the worst shit ever. Most of the time it just keep spinning or redirecting to itself in an infinite loop. There's no reliable way to get the csv?
*
Perseverance was my only answer.

Worst ever indeed. Sometimes just to get the yesterday's daily usage.csv takes me like 15 mins of retrying.

Tonight specifically energy dashboard maintenance, for better or for worse. *sigh*

But eventually I managed download all available daily data. Oldest I could get was 31/7/2023.

user posted image
Smart meter was installed Nov 2020.

user posted image
Of course, need to graph it. sweat.gif

This post has been edited by soonwai: Oct 12 2025, 12:33 AM
coolguy_0925
post Oct 12 2025, 12:39 AM

Look at all my stars!!
*******
Senior Member
4,535 posts

Joined: Jan 2003
again, it is down for maint until 0300
kk131
post Oct 12 2025, 08:12 AM

On my way
****
Junior Member
566 posts

Joined: Jun 2005
From: Somewhere over the rainbow


QUOTE(zellleonhart @ Oct 12 2025, 12:05 AM)
Didn't know got someone did similar excel like me. Mine not as canggih but just for me to do rough estimation.

The energy dashboard web app is the worst shit ever. Most of the time it just keep spinning or redirecting to itself in an infinite loop. There's no reliable way to get the csv?
*
I had a better experience downloading the csv's early in the morning.
netflix2019
post Oct 12 2025, 11:44 AM

Casual
***
Junior Member
411 posts

Joined: Jun 2022
QUOTE(soonwai @ Oct 11 2025, 05:28 PM)
So this month, I go micro manage the whole house punya TNB usage.

user posted image
2 more days to go. TNB bill forecast for this month: just above RM72.73

Always-on culprits.
1. SK Magic Water purifier Cold Water Tank
2. Ancient Aego M 2.1 speakers.
3. Back lane and front porch lights. Will probably have to live with this.
4. TPLink UH720 Powered USB hub
*
Wah aegoM 2.1 kaki. Cheers.

Consume so much letrik? I have 2 in my house somemore.
TSsoonwai
post Oct 30 2025, 02:05 PM


********
All Stars
11,450 posts

Joined: Oct 2007
From: KL


QUOTE(netflix2019 @ Oct 12 2025, 11:44 AM)
Wah aegoM 2.1 kaki. Cheers.

Consume so much letrik? I have 2 in my house somemore.
*
Awesome speakers. I got 2 white ones and a black one but now only left one pair still in use. I just use basic watt meter at wall socket, the Aego macam no standby mode, consuming 15-20W even when not in use.
netflix2019
post Oct 30 2025, 02:17 PM

Casual
***
Junior Member
411 posts

Joined: Jun 2022
QUOTE(soonwai @ Oct 30 2025, 02:05 PM)
Awesome speakers. I got 2 white ones and a black one but now only left one pair still in use. I just use basic watt meter at wall socket, the Aego macam no standby mode, consuming 15-20W even when not in use.
*
start with 1 set. then someone posted in garage sale selling satellite speaker rm50 cos woofer rosak liao. Bought both the satelite speaker rm100.

Then found someone selling their 2.1 set rm400 i think. A vietnamese in MMU cyberjaya packing preparing to leave Malaysia.

So now got two set with 3 satellite each. 1 for tv 1 for my PC. I hook them both to amplifier somemore, no rosak. crazy durable.

 

Change to:
| Lo-Fi Version
0.0163sec    0.42    6 queries    GZIP Disabled
Time is now: 25th November 2025 - 01:47 PM