In Progress

detect differences between estimated and actual energy consumption

I have a graph which is used to model a typical energy customers gas consumption over a year. A customer can join my company at at the start of their 12 mo th contract they will tell us how much gas they believe they will use in the next 12 months.

Periodically they will provide meter readings.

We need to use these meter readings to detect when the customers actual consumption differs significantly from what we have estimated they would have used, and to use their actual readings to adjust the model to predict what their actual usage is likely to be over the 12 month period.

It is also possible that a customers usage may be exactly as expected for several months and then their actual usage can change because of a change in their lifestyle (they may go on maternity leave or install a heated swimming pool) so we would need to detect these anomalies.

Skills: Data Science, Excel, Mathematics

See more: estimated electric bill too high, what is an estimated electricity bill, how are electricity bills estimated, do i have to pay an estimated electric bill, estimated vs actual electric bill, estimated vs. actual meter readings, estimated meter reading, estimated bill meaning, number trials increases differences number actual, screensaver energy consumption, detect differences wmv decoding, 2010 data total energy consumption personal computers, 2010 data total energy consumption electronic displays, energy consumption research papers, energy consumption servers, energy consumption graph 2010, total energy consumption till 2010, energy consumption ns2, united states 2010 energy consumption, predicted energy consumption graph

About the Employer:
( 2 reviews ) United Kingdom

Project ID: #17586958

Awarded to:


Hi, My name is Andran and I have a BSc and MSc in Mechanical Engineering. I have 11 years of experience with data analysis and creating tools to analyse data. I will use the graph you have and fit it to a set of equ More

$100 USD in 3 days
(0 Reviews)

34 freelancers are bidding on average $118 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$200 USD in 2 days
(587 Reviews)

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 385 + projects with 100% client satisfaction. I have more than 5 More

$250 USD in 4 days
(257 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.

$200 USD in 5 days
(271 Reviews)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$200 USD in 3 days
(200 Reviews)

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$100 USD in 3 days
(99 Reviews)

Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. More

$150 USD in 3 days
(57 Reviews)

Hello, there, I am very happy to put my bid on your project. I am an expert of algorithm and senior software developer, so I am interested in and confident to do this project. I hope to discuss everything of the pro More

$150 USD in 3 days
(29 Reviews)

- Based on the Estimated consumption by the consumer, and the actuals recorded at any point of time, can identify the customers who have had a drastic change in the consumption from what was estimated. - Giving a pict More

$200 USD in 4 days
(45 Reviews)

Hi I am an Engineering undergraduate with exceptional skills in mathematics. I am well experienced in machine learning algorithms and predictions, regression etc. I can help you to do this. Please message to discuss f More

$155 USD in 10 days
(102 Reviews)

Hi, I am a control engineering expert and a talented matlab coder. If you give me this project, you will get a good result. Thanks. Relevant skills & experiences: Electrical Engineering, Electronics, Engineering, Math More

$155 USD in 3 days
(16 Reviews)

I am a professional Excel Expert and Data Analyst holding years of experience in utilizing advance level tools and functions of Excel to perform data analysis, financial analysis, creating dynamic and automated charts, More

$50 USD in 1 day
(34 Reviews)

Hi, im an engineer and i can provide you a solution for the trquirement. We can generate formulars for next 12 months which vary with the present consumption. We need to do a coding within excel and it will automatical More

$150 USD in 1 day
(20 Reviews)

hi, I can perform a data exploratory analysis for the data and identify key features using dimension reduction methods. I can provide you pleasing visualizations with contemporary libraries and methods which would More

$161 USD in 5 days
(7 Reviews)

Hello, Greetings of the day.!! I can develope A forecast model which can predict the usage of user Your project attracted my attention at first glance, because I've really rich experience in Machine Learning & Pytho More

$111 USD in 5 days
(3 Reviews)

Hi I would like to work for you. I will provide highly credible analysis with my senior level experience. You may validate my profile which is also certified as “Preferred Freelancer” and the highest trust score - More

$120 USD in 4 days
(5 Reviews)

Hi, Good Day! I am a PMO Analyst and my primary task is the creation of Financial Reports. I am exposed on different excel formulas and functions. I am also a VBA Macro developer which I think a big plus to compl More

$50 USD in 1 day
(4 Reviews)

dear Sir, I can do this project. I have 5-year experience in programming, I can assure you that if you work with me once, you will always work with me for these kinds of projects.

$88 USD in 3 days
(1 Review)

I think I know what is necessary to help you with this. I think it will take a little bit of communication between us to get it perfect though. I would appreciate a sample of the data to play with to ensure I can help More

$100 USD in 3 days
(2 Reviews)

Hi, there - My name is Phong. I have read your job description and I am very interested in this project because I have good experience with mathematics and data science. I would love to speak with you further about t More

$150 USD in 3 days
(0 Reviews)

Dear Sir, I would like to apply for this project, but I would have questions: - the description says that you have a graph, or is there a graph to be created? - do you have the statistics for typical usage change in More

$45 USD in 1 day
(0 Reviews)