Exponential Smoothing

  • Thread starter Thread starter wanabe
  • Start date Start date
W

wanabe

Could use some help with an excel formula. I have a list of data
(numbers), dating back some years. I am looking to weigh the value of
these numbers, with more weight to current numbers and less to older
values. Can this be accomplished with the "Expondist" formula?
If not, is there an array formula that would get me to where I want to
be.
Thanking you in advance for your assistance.
 
Could use some help with an excel formula.  I have a list of data
(numbers), dating back some years.  I am looking to weigh the value of
these numbers, with more weight to current numbers and less to older
values.  Can this be accomplished with the "Expondist" formula?
If not, is there an array formula that would get me to where I want to
be.
Thanking you in advance for your assistance.
Click to expand...


Can you please provide some sample data with the result you are
expecting to get from it, since it will be easy to answer.
 
Can you please provide some sample data with the result you are
expecting to get from it, since it will be easy to answer.
Click to expand...

Good Morning
Here is the result I am looking for:

RESULT DATE AMOUNT VALUE
10 ENTRIE FULL VALUE 6/26 1.21 1.21
10 ENTRIE FULL VALUE 6/26 5.00 5.00
10 ENTRIE FULL VALUE 6/26 1.36 1.36
10 ENTRIE FULL VALUE 6/26 1.26 1.26
10 ENTRIE FULL VALUE 6/26 1.26 1.26
10 ENTRIE FULL VALUE 6/26 2.44 2.44
10 ENTRIE FULL VALUE 6/26 2.31 2.31
10 ENTRIE FULL VALUE 6/26 2.31 2.31
10 ENTRIE FULL VALUE 6/26 1.01 1.01
10 ENTRIE FULL VALUE 6/26 8.75 8.75
NEXT 10 90% OF VALUE 6/26 1.18 1.06
NEXT 10 90% OF VALUE 6/25 1.36 1.22
NEXT 10 90% OF VALUE 6/25 1.26 1.13
NEXT 10 90% OF VALUE 6/25 1.26 1.13
NEXT 10 90% OF VALUE 6/25 1.01 0.91
NEXT 10 90% OF VALUE 6/25 1.18 1.06
NEXT 10 90% OF VALUE 6/25 1.18 1.06
NEXT 10 90% OF VALUE 6/24 1.26 1.13
NEXT 10 90% OF VALUE 6/24 1.26 1.13
NEXT 10 90% OF VALUE 6/24 1.01 0.91
NEXT 10 80% OF VALUE 6/24 2.31 1.85
NEXT 10 80% OF VALUE 6/24 1.01 0.81
NEXT 10 80% OF VALUE 6/23 9.75 7.80
NEXT 10 80% OF VALUE 6/23 4.88 3.90
NEXT 10 80% OF VALUE 6/23 1.32 1.06
NEXT 10 80% OF VALUE 6/23 1.26 1.01
NEXT 10 80% OF VALUE 6/23 7.75 6.20
NEXT 10 80% OF VALUE 6/22 10.00 8.00
NEXT 10 80% OF VALUE 6/22 4.88 3.90
NEXT 10 80% OF VALUE 6/22 4.88 3.90

Hope this helps.
 
Good Morning
Here is the result I am looking for:

            RESULT                         DATE     AMOUNT     VALUE
10 ENTRIE FULL VALUE    6/26    1.21    1.21
10 ENTRIE FULL VALUE    6/26    5.00    5.00
10 ENTRIE FULL VALUE    6/26    1.36    1.36
10 ENTRIE FULL VALUE    6/26    1.26    1.26
10 ENTRIE FULL VALUE    6/26    1.26    1.26
10 ENTRIE FULL VALUE    6/26    2.44    2.44
10 ENTRIE FULL VALUE    6/26    2.31    2.31
10 ENTRIE FULL VALUE    6/26    2.31    2.31
10 ENTRIE FULL VALUE    6/26    1.01    1.01
10 ENTRIE FULL VALUE    6/26    8.75    8.75
NEXT 10 90% OF VALUE    6/26    1.18    1.06
NEXT 10 90% OF VALUE    6/25    1.36    1.22
NEXT 10 90% OF VALUE    6/25    1.26    1.13
NEXT 10 90% OF VALUE    6/25    1.26    1.13
NEXT 10 90% OF VALUE    6/25    1.01    0.91
NEXT 10 90% OF VALUE    6/25    1.18    1.06
NEXT 10 90% OF VALUE    6/25    1.18    1.06
NEXT 10 90% OF VALUE    6/24    1.26    1.13
NEXT 10 90% OF VALUE    6/24    1.26    1.13
NEXT 10 90% OF VALUE    6/24    1.01    0.91
NEXT 10 80% OF VALUE    6/24    2.31    1.85
NEXT 10 80% OF VALUE    6/24    1.01    0.81
NEXT 10 80% OF VALUE    6/23    9.75    7.80
NEXT 10 80% OF VALUE    6/23    4.88    3.90
NEXT 10 80% OF VALUE    6/23    1.32    1.06
NEXT 10 80% OF VALUE    6/23    1.26    1.01
NEXT 10 80% OF VALUE    6/23    7.75    6.20
NEXT 10 80% OF VALUE    6/22    10.00   8.00
NEXT 10 80% OF VALUE    6/22    4.88    3.90
NEXT 10 80% OF VALUE    6/22    4.88    3.90

Hope this helps.
Click to expand...



Hi,

I assume that you are looking for the RESULT in Column A and your
remaining data is like the below:-

DATE in Column B
AMOUNT in Column C
VALUE in Column D

At the same time I assume that the FIRST ROW of the sheet is having
the COLUMN HEADERS and the data starts from 2ND ROW.

I am using the E column as Helper Column.
Copy and paste the below formula in E2 cell.
=IF(OR($C2="",$D2=""),"",ROUND($D2/$C2*100,0))
Drag the E2 cell formula to the remaining cells of E Column based on
the C & D Column Data.

Copy and paste the below formula in F2 cell.
=IF($E2="","",IF($E2=100,COUNTIF($E:$E,$E2)&" ENTRIE FULL VALUE","NEXT
"&COUNTIF($E:$E,$E2)&" "&$E2&"%"&" OF VALUE"))
Drag the F2 cell formula to the remaining cells of F Column based on
the C & D Column Data.
Keep in mind that the F Column Formula will work based on the E Column
formula, so both the formula’s should be applied based on the C&D
Column data.

Hope it’s clear.
 
Back
Top