December 1, 2008 04:24pm pst

1. zorvek 2,849,429
2. rorya 2,281,815
3. saurabh726 2,202,034
4. byundt 986,020
5. chris_bot... 936,272
6. nutsch 703,828
7. patrickab 570,747
8. brettdj 546,870
9. matthews... 497,834
10. webtubbs 445,798
11. jeverist 415,838
12. ahammar 362,441
13. spattewar 330,928
14. jpaulino 285,447
15. Psychotec 280,750
16. RobSamp... 279,314
17. epaclm 247,475
18. irudyk 241,776
19. dj88 216,941
20. WJReid 194,934
21. weellio 155,519
22. Merch_Ops 144,713
23. GrahamSkan 141,260
24. barryhou... 138,530
25. StellanRo... 131,168

1. zorvek 10,153,920
2. byundt 7,729,109
3. rorya 5,976,546
4. matthews... 3,060,962
5. jeverist 2,826,107
6. patrickab 2,326,310
7. saurabh726 2,295,613
8. roos01 1,923,578
9. brettdj 1,589,446
10. webtubbs 1,542,190
11. mvidas 1,529,753
12. fanpages 1,236,922
13. chris_bot... 1,125,778
14. MalicUK 1,060,396
15. nutsch 703,828
16. ahammar 662,574
17. mgh_mgh... 649,110
18. LoNeRaV... 602,049
19. ture 572,551
20. spattewar 539,877
21. R_Rajesh 468,975
22. jpaulino 398,346
23. david251 380,578
24. RobSamp... 377,863
25. gtgloner 350,884

09.03.2008 at 08:37AM PDT, ID: 23699615

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.2

Create a log of times that a computer has been turned on and off. Perhaps using event log data?

Asked by rberke in Microsoft Excel Spreadsheet Software, Miscellaneous Programming, Automation

I already have written an excel macro that produces the spreadsheet shown below.

Right now, the input to this macro is coming from a .txt file created by a utility for measuring disk temperatures every few minutes ("hdd thermometer" from http://www.rsdsoft.com/)

For some reason that .txt file does not always get timely updates, so I am looking for alternative sources of time logs that I could use instead.

I am thinking of writing my own program that appends a date/time entry to a text file, then schedule it to run every 10 minutes.

But, I am wondering if anybody knows of an existing source of timestamped log data that I can get into excel.
For instance, does anybody know how to read the contents of the windows event logs into an excel worksheet?
Or maybe somebody knows another source for similar time logs? I don't care much if the time logged is "user logged on" or simply "computer turned on", but I have slight preference for "user logged on".

Here is what my spreadsheet currently generates:

8/28/2008 15:21            OFF AT --------------Thursday 08/28/08 03:21:15 PM
8/28/2008 16:19            ON AT ---------------Thursday 08/28/08 04:19:56 PM (00:58:41 later.)
8/28/2008 16:20            on
8/28/2008 16:49            on <5 preceeding "on" records were deleted because they are boring (their gaps were less than 10 minute long)>
8/28/2008 16:56            on
8/28/2008 16:57            OFF AT --------------Thursday 08/28/08 04:57:15 PM
8/28/2008 17:38            ON AT ---------------Thursday 08/28/08 05:38:55 PM (00:41:40 later.)
8/28/2008 17:43            on
8/28/2008 17:58            on <3 preceeding "on" records were deleted because they are boring (their gaps were less than 10 minutes long)>

Start Free Trial

Keywords: Create a log of times that a computer h…

	Title
1	How to use Worksheet_SelectionCha…
2	Bored <Understatement>
3	New motherboard and computer tempe…
4	Excel spreadsheet and C++
5	temperature measure
6	I'm bored.

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Create a log of times that a computer has been turned on and off. Perhaps using event log data?

Asked by rberke in Microsoft Excel Spreadsheet Software, Miscellaneous Programming, Automation

About this solution