Find Jobs
Hire Freelancers

detect differences between estimated and actual energy consumption

$30-250 USD

In Progress
Posted over 5 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 17586958

About the project

27 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 equations. The actual data will then be compared to these equations and scaled as needed. After an anomaly in the usage, the equations will be adjusted only for the time period after the major change has occurred. This complex problem will be handled by breaking it down into smaller, more manageable sections. The end result will be a highly accurate tool that will be able to compensate for any number of anomalies while still predicting future use based on your graph. I will be able to deliver this as an Excel file or an Exe file. If you have any questions for me or would like to discuss some finer details of your project, feel free to contact me on ope at knaenterprise dot com. Thanks and regards Andran Naicker
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
27 freelancers are bidding on average $119 USD for this job
User Avatar
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 years of the experience in Data Science, Excel, Mathematics Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. Thanks.
$250 USD in 4 days
4.9 (509 reviews)
8.3
8.3
User Avatar
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
5.0 (484 reviews)
8.0
8.0
User Avatar
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
5.0 (320 reviews)
7.4
7.4
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$100 USD in 3 days
4.9 (122 reviews)
7.1
7.1
User Avatar
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, graphs and tables. I will be happy to discuss in detail how I am highly suitable for this project.
$50 USD in 1 day
4.8 (188 reviews)
7.1
7.1
User Avatar
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 further on this Thnks Note-please check my profile for past projects and reviews.
$155 USD in 10 days
5.0 (111 reviews)
5.8
5.8
User Avatar
- 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 picture on what the consumption would be upcoming months. - Have done projects similar to this where the recording for a period of one year and for evey half hour interval. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$200 USD in 4 days
4.7 (50 reviews)
6.1
6.1
User Avatar
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 complete this project. You can check my reviews to help you decide. Feel free to message me anytime to discuss this project. Thank you
$50 USD in 1 day
4.7 (76 reviews)
5.4
5.4
User Avatar
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 automatically predict the requirement for next 12 months.
$150 USD in 1 day
5.0 (23 reviews)
5.1
5.1
User Avatar
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 help us identity things. I reckon the data is a time-series. I have good experience in time-series and they require special methods for classification and pattern identification. I am well versed with modern frameworks such as TensorFlow, scikit learn and can handle most types of data. I would like to take a look into the actual data and propose a roadmap for providing you the solution. With Regards, Anthony
$161 USD in 5 days
5.0 (10 reviews)
4.4
4.4
User Avatar
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 & Python Programming. I have worked on several similar projects before! I'm really confident about your project, and very eager to join your project. I am having 3+ year of experience in Data Science using tools like Python, R, Spark. Worked on multiple projects in various domains like life sciences, CPG, Insurance. I have completed Master of Technology in Machine Learning. If we have a chance to cooperate, I'll do my best to provide wonderful result. Work Areas - Image Processing, Text Mining, Supervised and Unsupervised Machine learning problem, Voice Analytics. Thanks, Analix D
$111 USD in 5 days
4.8 (22 reviews)
4.8
4.8
User Avatar
hi, I am a professional financial analyst, and I have the reauired abilities to do this report for you immediately, just accept my bid Regards
$30 USD in 1 day
5.0 (6 reviews)
4.0
4.0
User Avatar
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 - 100%. You may look at my sample work and latest reviews of 43/50 Five Stars. I am a qualified professional having long industry experience in Business, Strategy and Finance with extensive research and writing exposure in this platform. With this background, I will be able to deliver better service for you. Look forward to hearing from you. Best Regards / Sanjib
$120 USD in 4 days
4.0 (9 reviews)
4.3
4.3
User Avatar
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
4.6 (3 reviews)
2.9
2.9
User Avatar
I am very fluent in all things excel! I am best in formulas and VBA coding work inside of Excel. I am also very good with data entry. Would love to work with you!
$138 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm good a math and can work with presence of mind for the work. Give me a chance and I'll show my efforts.
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Sir, Currently I am a student of MS mathematics and have completed my master's in mathematics. I believe in a long-term relationship with my client the trust is more worthy to me than money. That's why I always assure quality work within given time and resources. I do only what I love to do. Work is my passion. Regards, Muhammad Uzair Arshad
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Business Accounting and Bookkeeping : Business owner you have more important things to do than to keep your own books. Let our team take care of your books for you, so you can focus on running your business and generating profits. Each month or quarter we will do the following for you: – Reconcile your bank accounts and credit card statements – Generate an income statement – Generate a balance sheet – Clean up your general ledger – Personalized consultations to keep you up to date We also provide weekly services, including check writing and assistance in Accounts Payable for our clients If you would like to accounting services may i help you. Our services are offered remotely, virtually or online. All work is done over the Internet. So, it really does not matter where you are located. You can benefit from our services!
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am currently working as a Data analyst, I solely created a sales forecast model for the the firm using ensemble machine learning, and I have a strong statistical background being a graduate from IIT Relevant Skills and Experience Excel, python, machine learning, VB analysis, SQL, Insight generation, random forest, linear Regression, xgboost, GBM, LGBM, Decision tree
$88 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 colder periods? Regards Péter
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
2
Member since Jul 1, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.