Excel formula references

I have a data list that will grow over time. The values are listed vertically in a column; most recent value at the bottom. I am trying to figure out how to setup a formula to figure out the standard deviation on the most recent 30 values automatically. For instance if the column contains 30 values and I add the 31st value, I'd like to have to have the standard deviation displayed in a cell and automatically shift from calculating on values 1-30 to values 2-31. Is this possible?

Jeff.

Looking in Books On Line (http://technet.microsoft.com/en-us/library/ms159220.aspx), I see that StDev is not a supported expression for export to Excel. Specifically:

For all other cases, such as an unsupported expression, a formula is not generated for Excel. Instead, the value is placed in directly in the cell.

This means that you would be required to calculate your standard deviation 'by hand' for the last 30 of the items in your list.

Is it a requirement that the calculation be done in the spreadsheet? How about having the standard deviation calculation done by a SQL query? TSQL has the STDEV to calculate a sample standard deviation and STDEVP to calculate a population standard deviation. Add a new dataset that calculates the correct standard deviation from the last 30 entries (sort in decending order and use the top command) and then display the value where the RowNumber equals the CountRows in your table.

Larry

Event ID 19011 Error 8335

I am getting this Warning in my Event logs and can find no reference from
any source. I find lots of references to Error 8344. The SQL user is a
member of the Local Administrators group as referenced in Q830215. I have
also seen statement that indicate this is benign. The contents of the Error
box are:
SuperSocket info: (SpnRegister) : Error 8335.
Thanks in advance for any help.
Monty,
This is related to Kerberos. A little more information is available at:
http://support.microsoft.com/default...b;en-us;811889
Russell Fields
"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> I am getting this Warning in my Event logs and can find no reference from
> any source. I find lots of references to Error 8344. The SQL user is a
> member of the Local Administrators group as referenced in Q830215. I have
> also seen statement that indicate this is benign. The contents of the
Error
> box are:
> SuperSocket info: (SpnRegister) : Error 8335.
>
> Thanks in advance for any help.
>
|||Thanks for your help Russell. In carefully reviewing the doc on the link and
comparing to my situation, I find that I meet the criteria in all instances
and still the error. I also notice that the specific error mentioned is 8344
about which there is a LOT of information available, just not 8335.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23biGioNcEHA.3580@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Monty,
> This is related to Kerberos. A little more information is available at:
> http://support.microsoft.com/default...b;en-us;811889
> Russell Fields
> "Monty" <montysl@.nospam.hotmail.com> wrote in message
> news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
from[vbcol=seagreen]
have
> Error
>

Event ID 19011 Error 8335

I am getting this Warning in my Event logs and can find no reference from
any source. I find lots of references to Error 8344. The SQL user is a
member of the Local Administrators group as referenced in Q830215. I have
also seen statement that indicate this is benign. The contents of the Error
box are:
SuperSocket info: (SpnRegister) : Error 8335.
Thanks in advance for any help.Monty,
This is related to Kerberos. A little more information is available at:
http://support.microsoft.com/defaul...kb;en-us;811889
Russell Fields
"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> I am getting this Warning in my Event logs and can find no reference from
> any source. I find lots of references to Error 8344. The SQL user is a
> member of the Local Administrators group as referenced in Q830215. I have
> also seen statement that indicate this is benign. The contents of the
Error
> box are:
> SuperSocket info: (SpnRegister) : Error 8335.
>
> Thanks in advance for any help.
>|||Thanks for your help Russell. In carefully reviewing the doc on the link and
comparing to my situation, I find that I meet the criteria in all instances
and still the error. I also notice that the specific error mentioned is 8344
about which there is a LOT of information available, just not 8335.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23biGioNcEHA.3580@.TK2MSFTNGP11.phx.gbl...
> Monty,
> This is related to Kerberos. A little more information is available at:
> http://support.microsoft.com/defaul...kb;en-us;811889
> Russell Fields
> "Monty" <montysl@.nospam.hotmail.com> wrote in message
> news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
from[vbcol=seagreen]
have[vbcol=seagreen]
> Error
>

Event ID 19011 Error 8335

I am getting this Warning in my Event logs and can find no reference from
any source. I find lots of references to Error 8344. The SQL user is a
member of the Local Administrators group as referenced in Q830215. I have
also seen statement that indicate this is benign. The contents of the Error
box are:
SuperSocket info: (SpnRegister) : Error 8335.
Thanks in advance for any help.Monty,
This is related to Kerberos. A little more information is available at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Russell Fields
"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> I am getting this Warning in my Event logs and can find no reference from
> any source. I find lots of references to Error 8344. The SQL user is a
> member of the Local Administrators group as referenced in Q830215. I have
> also seen statement that indicate this is benign. The contents of the
Error
> box are:
> SuperSocket info: (SpnRegister) : Error 8335.
>
> Thanks in advance for any help.
>|||Thanks for your help Russell. In carefully reviewing the doc on the link and
comparing to my situation, I find that I meet the criteria in all instances
and still the error. I also notice that the specific error mentioned is 8344
about which there is a LOT of information available, just not 8335.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23biGioNcEHA.3580@.TK2MSFTNGP11.phx.gbl...
> Monty,
> This is related to Kerberos. A little more information is available at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
> Russell Fields
> "Monty" <montysl@.nospam.hotmail.com> wrote in message
> news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> > I am getting this Warning in my Event logs and can find no reference
from
> > any source. I find lots of references to Error 8344. The SQL user is a
> > member of the Local Administrators group as referenced in Q830215. I
have
> > also seen statement that indicate this is benign. The contents of the
> Error
> > box are:
> > SuperSocket info: (SpnRegister) : Error 8335.
> >
> >
> >
> > Thanks in advance for any help.
> >
> >
>