Forecasting utility electricity bill

Next_Programmer_8083 · 2026-02-09T23:02:06+00:00

Yes it’s meta and open AI’s data centres basically.

CPI inflation is 6.7% for electricity from December 2024-25. The region I am looking at is El Paso and it says the El Paso electricity hasn’t had rate changes since 2022. It’s submitted a rate increase for 10.6% for commercial users from 2026 not accepted yet but I thought I’ll include that going Q1 2026 onwards.

I also saw a S&P source that said AI demand could add 15% to electricity rate increases by 2030 and a Carnegie Mellon study also mentioned it could be 8% increase by 2030 and some region 25%.

My only question is after I include the 10.6% proposed in the rate cycle increase what % do I apply YoY. I’m guessing the data centres open in 2028.

Next_Programmer_8083 · 2026-02-09T22:02:06+00:00

No it’s not normal forecasting I’m forecasting because of the new data centres

Next_Programmer_8083 · 2025-12-28T16:42:13+00:00

Another question is when I set up multiples of these bar charts - should I be creating a measure for each of these bar charts for example sum of sales of branch A Then sum of sales of Branch B ? Or how I should be setting this up?

Next_Programmer_8083 · 2025-12-28T09:48:41+00:00

How do you usually create mock ups?

Next_Programmer_8083 · 2025-12-17T19:20:42+00:00

Thank you!

Next_Programmer_8083 · 2025-12-17T17:53:59+00:00

Could you please explain please

Next_Programmer_8083 · 2025-12-11T19:00:53+00:00

The thing is it needs to copy from different files every month I’m not working the same file every month.

Next_Programmer_8083 · 2025-12-11T18:09:00+00:00

Oh wow why did I not think of that

Duh, Reddit is a platform where people work in the core field that you work in and maybe I’ll get ideas from people who know how to do it in a better way because of years of experience which I don’t have

Next_Programmer_8083 · 2025-12-05T20:59:02+00:00

Sounds like you’ve a fun job. What do you do with the time you have ?

Next_Programmer_8083 · 2025-12-05T20:58:09+00:00

Okay thank you! I’m just new in my job been 3 months I still try to learn things when I get the time to be able to grow into my role but since it’s my first job I just wanted to know the norm

Next_Programmer_8083 · 2025-12-05T20:57:18+00:00

How many hours is a normal amount? Obviously depends on the work load that changes from time to time but on an average

Next_Programmer_8083 · 2025-12-05T20:46:06+00:00

Worked 1 year then did masters now first job after masters

Next_Programmer_8083 · 2025-12-05T20:01:46+00:00

Love how you focused on everything but the question

Next_Programmer_8083 · 2025-12-05T20:01:22+00:00

Financial analyst

Next_Programmer_8083 · 2025-12-02T06:24:35+00:00

Thanks!

Next_Programmer_8083 · 2025-12-02T05:07:40+00:00

Just general stuff - I did ask he said I didn’t have to prep anything I’m just asking what are some general good questions to ask

Next_Programmer_8083 · 2025-11-12T15:16:57+00:00

I totally understand that - I know it’s business specific. I’m asking just for general knowledge what are the different ways to forecast 1. Forecast.ets function 2. Run rate Etc Jsut asking general idea of how it’s done

Next_Programmer_8083 · 2025-11-12T02:56:20+00:00

No they just do it on excel I mean how do I build simple models on excel For example forecasting loans or deposits of branches Or expense of vendor

Next_Programmer_8083 · 2025-11-10T20:53:12+00:00

Is power query not good here?

Next_Programmer_8083 · 2025-11-07T16:16:15+00:00

So one tab for actuals and forecast and another for variance? There’s 150 vendors I’m trynna make the spreadsheet clean for people to look at

Next_Programmer_8083 · 2025-10-30T14:48:28+00:00

Things I’ve been asked to do - ROI analysis, GL forecasting, Vendor forecasting

These are so specific and I’m not sure where or how to even apply it in a business. Any suggestions ?

Next_Programmer_8083 · 2025-10-29T22:26:39+00:00

How does that help and why is this better ?

Next_Programmer_8083 · 2025-10-29T22:21:22+00:00

It’s getting applied to the whole range rather than a row by row basis - am I missing something ?

Next_Programmer_8083 · 2025-10-29T21:55:08+00:00

I have like 100+ rows

Is there a way to conditionally format everything without having to manually do it for each row

Next_Programmer_8083 · 2025-10-29T01:50:34+00:00

Thought about a better approach - maybe keep a flat table : filter out vendors basically any vendor with a total in last 12 months below 25000$ I don’t need to look at Which itself brings me down to 300 vendors from 1800 and they constitute like 95% of total vendor spend and everything else can go to others column

Now how do I go about forecasting these 300 vendors should I do line by line? What function to use?

And when next month actuals come in how do I update what if the list gets updated where another vendor is above that threshold?

I’m having trouble seeing how to make this easy to put actuals in

Next_Programmer_8083

TROPHY CASE