Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

SP Group Instructions

Procedure

Step 1) Go to https://www.spgroup.com.sg/dam/spgroup/docs/our-services/utilities/tariff-information/Historical-Electricity-Tariff_Oct-18-w-GST-.xlsx

Step 2) Choose the 'SPWebsite (without GST)' Tab and input the most recent month and the 2 following on the 'Month' column on the spreadsheet. Input the year on the 'Year' column accordingly

image.png

Step 3) Check the value of the most recent period column and the 'HIGH TENSION LARGE (HTL) SUPPLIES → Peak period (7.00am to 11.00pm)' line. IT IS THE VARIABLE 'A' ON THE EQUATION ON STEP 6

image.png

Step 4) Check the value of the most recent period column and the 'HIGH TENSION LARGE (HTL) SUPPLIES → Off-peak period (11.00pm to 7.00am)' line**. IT IS THE VARIABLE 'B' ON THE EQUATION ON STEP 6**

image.png

Step 5) Calculate the sum C = (16A + 8B)/24

Step 6) Input the resulting number 'C' value on the Value 1 column

Below is just an example for the data in the prints above

image.png

Step 7) Repeat the procedure step 1) trough step 6) for the previous quarter in the spreadsheet (the previous column).

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.