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.
34 freelancers are bidding on average $118 for this job
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
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.