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

Excel 2007 Documents Not Displayed in Windows XP Professional sp2 Start Menu Recent Documents Li

---

Excel 2007 Documents Not Displayed in Windows XP Professional sp2

Start Menu's Recent Documents List:

---

Dear Microsoft Support:

I can't figure out how to get recently used Excel 2007 (new file formats) documents to show up in the Windows XP Professional (sp2) Start Menu's Recent Documents List.I checked the Internet, the knowledgebase, many parts of the MS web site, etc. for an answer but can't find one.

Are Excel 2007 documents supposed to show up in the XP Start Menu's Recent Document List?Is this a bug or do I have to do some sort of configuration to make it do so? If it's a bug, when will a fix be available?

Are these new Excel 2007 files filtered out like EXE files are which will not appear in the Recent Document List?

The Excel 2007 file types are listed in the Registry.

This question is also posted on Experts-Exchange...No solutions yet.

Thanks.

Jim.

This forum is nothing to do with Excel. Nothing to do with Windows XP. And it isn't a route to Microsoft Support.

Perhaps you should try elsewhere.

Excel 2007 Documents Not Displayed in Windows XP Professional sp2 Start Menu Recent Document

---

Excel 2007 Documents Not Displayed in Windows XP Professional sp2

Start Menu's Recent Documents List:

---

Dear Microsoft Support:

I can't figure out how to get recently used Excel 2007 (new file formats) documents to show up in the Windows XP Professional (sp2) Start Menu's Recent Documents List.I checked the Internet, the knowledgebase, many parts of the MS web site, etc. for an answer but can't find one.

Are Excel 2007 documents supposed to show up in the XP Start Menu's Recent Document List?Is this a bug or do I have to do some sort of configuration to make it do so? If it's a bug, when will a fix be available?

Are these new Excel 2007 files filtered out like EXE files are which will not appear in the Recent Document List?

The Excel 2007 file types are listed in the Registry.

This question is also posted on Experts-Exchange...No solutions yet.

Thanks.

Jim.

This forum is nothing to do with Excel. Nothing to do with Windows XP. And it isn't a route to Microsoft Support.

Perhaps you should try elsewhere.

Event ID: 17830?

All,
Can't figure out why I am getting this message in my event log...
Event Type: Error
Event Source: MSSQL$SQLSERVER2005
Event Category: (4)
Event ID: 17830
Date: 9/14/2005
Time: 7:06:03 AM
User: N/A
Computer: ADDVMFM12
Description:
A network error occurred while establishing a connection; the connection has
been closed. This may have been caused by client or server login timeout
expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
ms, validating login 0 ms. [CLIENT: 10.13.0.137]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a6 45 00 00 14 00 00 00 E.....
0008: 18 00 00 00 41 00 44 00 ...A.D.
0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
0028: 45 00 52 00 56 00 45 00 E.R.V.E.
0030: 52 00 32 00 30 00 30 00 R.2.0.0.
0038: 35 00 00 00 00 00 00 00 5......
Anyone have any idea why this is happening?
Thanks
MikeYou'll want to post this in the SQL Server 2005 CTP
newsgroups:
http://communities.microsoft.com/ne...lcid=us

-Sue
On Wed, 14 Sep 2005 07:23:14 -0400, "Mike"
<mgasperino@.mebtel.net> wrote:

>All,
>Can't figure out why I am getting this message in my event log...
>Event Type: Error
>Event Source: MSSQL$SQLSERVER2005
>Event Category: (4)
>Event ID: 17830
>Date: 9/14/2005
>Time: 7:06:03 AM
>User: N/A
>Computer: ADDVMFM12
>Description:
>A network error occurred while establishing a connection; the connection ha
s
>been closed. This may have been caused by client or server login timeout
>expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
>writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
>ms, validating login 0 ms. [CLIENT: 10.13.0.137]
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: a6 45 00 00 14 00 00 00 E.....
>0008: 18 00 00 00 41 00 44 00 ...A.D.
>0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
>0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
>0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
>0028: 45 00 52 00 56 00 45 00 E.R.V.E.
>0030: 52 00 32 00 30 00 30 00 R.2.0.0.
>0038: 35 00 00 00 00 00 00 00 5......
>Anyone have any idea why this is happening?
>Thanks
>Mike
>

Event ID: 17830?

All,
Can't figure out why I am getting this message in my event log...
Event Type: Error
Event Source: MSSQL$SQLSERVER2005
Event Category: (4)
Event ID: 17830
Date: 9/14/2005
Time: 7:06:03 AM
User: N/A
Computer: ADDVMFM12
Description:
A network error occurred while establishing a connection; the connection has
been closed. This may have been caused by client or server login timeout
expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
ms, validating login 0 ms. [CLIENT: 10.13.0.137]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a6 45 00 00 14 00 00 00 E.....
0008: 18 00 00 00 41 00 44 00 ...A.D.
0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
0028: 45 00 52 00 56 00 45 00 E.R.V.E.
0030: 52 00 32 00 30 00 30 00 R.2.0.0.
0038: 35 00 00 00 00 00 00 00 5......
Anyone have any idea why this is happening?
Thanks
Mike
You'll want to post this in the SQL Server 2005 CTP
newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
-Sue
On Wed, 14 Sep 2005 07:23:14 -0400, "Mike"
<mgasperino@.mebtel.net> wrote:

>All,
>Can't figure out why I am getting this message in my event log...
>Event Type: Error
>Event Source: MSSQL$SQLSERVER2005
>Event Category: (4)
>Event ID: 17830
>Date: 9/14/2005
>Time: 7:06:03 AM
>User: N/A
>Computer: ADDVMFM12
>Description:
>A network error occurred while establishing a connection; the connection has
>been closed. This may have been caused by client or server login timeout
>expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
>writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
>ms, validating login 0 ms. [CLIENT: 10.13.0.137]
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: a6 45 00 00 14 00 00 00 E.....
>0008: 18 00 00 00 41 00 44 00 ...A.D.
>0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
>0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
>0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
>0028: 45 00 52 00 56 00 45 00 E.R.V.E.
>0030: 52 00 32 00 30 00 30 00 R.2.0.0.
>0038: 35 00 00 00 00 00 00 00 5......
>Anyone have any idea why this is happening?
>Thanks
>Mike
>

Even and Odd numbers

I need to figure out how to pull records if the id is even or odd.
ie
ID Name
1 bill
2 john
3 joe
4 jane
for example i need a idea of a select statement that will pull the even records 2 and 4.
is this possible?you should able to use the modulo operator... something like (for even)

select *, CAST(ID AS int) % CAST(2 AS int) AS Modulo
from table where Modulo = 0

I think that should do it...

To do it for the odd numbers try this...

select *, CAST(ID AS int) % CAST(2 AS int) AS Modulo
from table where Modulo = 1|||thanks rockslide i will give that a crack.