smoothing

  1. U

    Exponential Smoothing for each Plant and Material

    I have over 800 lines of data. I am trying to create a forecast for each material based on the plant. I have consumption for two years. I want the forecast to be automatic so when someone enters the plant and material, the forecast is auto populated. Currently the issue I am having is how to...
  2. M

    Smoothing Data for Step Chart (to show flat lines and major increases)

    Hello, I've searched far and wide, and would greatly appreciate guidance for a method of smoothing increasing/decreasing data that results in flat lines separated by major increases, similar to a step line (but each line contains multiple points). I'm trying to create a chart to help identify...
  3. N

    adding more lines - when curve is acute

    Hi Im trying to create a virtual Harmonograph based upon Wiki page Harmonograph - Wikipedia, the free encyclopedia The spreadsheet (can be downloaded at http://spotprints.co.uk/harmonograph.xlsx) does go some way to that but I want to use the x,y values in Coreldraw and want to keep the...
  4. M

    Smoothing of Data

    I have 35 years of temperature data. I have the average of each day in a column. However, my data is noisy. How can I smooth the data? Do I need a filter and how would I do this?b I would like to send you the file but I can not attach files. PLEASE HELP!
  5. T

    Advanced Min-Max in Access

    Hi, I am looking at the transfering the following code from Excel VBA to Access VBA and was wondering if anybody could help me by telling me which factors I should look out for/ how I should change the code so as to make it functional. What the code does is to take an interval in a set of...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top