Personal Stats Tracking

[KodiakStar]

Since i've been laying around thinking tonight, and feeling like i have nothing better to do
(although i will only do the work at umm. the office...)...

Is there anyone else besides budec interested in having a Excel WorkSheet to track
your own personal stats? And what formula's would you like to have on the sheet?

I know a few other people have mentioned (both here and I have seen someon on the
main folding@home msg board @ stanford) that they track their own stats... So what
do you guys use for that Excel? Something else? What type of information do you
track for yourself?

 

[marty9876]

What type of information do you
track for yourself?

Honestly, I just try and keep 1/2 of what I go going. I recently got busy and just had time this weekend to see what was happening- found ~6-10 boxen not folding... Stupid HTTP error on Stanfords side, I think the server 150 problems of late.

 

[blakex]

Since i've been laying around thinking tonight, and feeling like i have nothing better to do
(although i will only do the work at umm. the office...)...

Is there anyone else besides budec interested in having a Excel WorkSheet to track
your own personal stats? And what formula's would you like to have on the sheet?

I know a few other people have mentioned (both here and I have seen someon on the
main folding@home msg board @ stanford) that they track their own stats... So what
do you guys use for that Excel? Something else? What type of information do you
track for yourself?

I've got an Excel spreadsheet that I track my 6 computers on, but it's fairly simplistic.

By Column:
1: Work Unit # (now 84)
2: Date of Work Unit Completion
3: Points for Work Unit
4. Total Points
5. Computer completing Work Unit
6. Number of Work Units completed by Said Computer
7. Number of Points completed by Said Computer
8. Rank on folding.stanford.edu (now 37193)
9. Rank on hardfolding.com (now 1343)
10: Points per Work Unit (now 195.2)
11: Days spent folding (now 32)
12: Work Units per Day (now 2.66)
13: Points Per Day (now 518.4)
14: Notes - just random notes for each unit.

I then have a floating table which tracks the 6 computers. Keeps track of the current work unit being worked on - including points for the unit and date of expected completion.

Overall, fairly simple, but it works for me. I also have a tab where I have recorded some of the benchmarks output by FAHMon, but that hasn't been updated in a while. I can post a screenshot if you'd like.

Total Points, Points per Work Unit, Work Units per Day and Points Per Day are all automatically calculated.

 

[budec]

What about having EMIII output HTML then mangle that up so it "auto-magically" keeps track of stats?

 

[OSUguy98]

I use EMIII to output all the data into an html..... then I copy/paste it into Excel..... I can send you what I have already.... it'll tell you just about everything you need to know and/or want to know......

I'm searching for the thread I posted in about it previously.........

Keep on Folding!! For the [H]orde!!

 

[KodiakStar]

I've got an Excel spreadsheet that I track my 6 computers on, but it's fairly simplistic.

I then have a floating table which tracks the 6 computers. Keeps track of the current work unit being worked on - including points for the unit and date of expected completion.

Total Points, Points per Work Unit, Work Units per Day and Points Per Day are all automatically calculated.

How does your Excel sheet pull the info, or do you input the info on your own?

 

[OSUguy98]

couldn't find the original thread I linked it to... but here is the basic output...... I have each computer on a different tab, and this is the summary page..... I manually copy EMIIIs output into an excel tab, sort it by boxen name and then cut and paste it to it's appropriate tab....... (after I make sure that the points values all exist,etc)


Keep on Folding!! For the [H]orde!!

 

[blakex]

How does your Excel sheet pull the info, or do you input the info on your own?

All just entered by hand - easy with just 6 computers (down to 4, but back up to 6 soon) folding right now. And since I'm averaging only 2.66 work units per day, the updates are pretty simple.

 

[unhappy_mage]

For those with fold-server boxes, your farm tracks its own progress/PPD. Take a look at ICE_9's page. Nice, no? It doesn't do historical data or make nice graphs, but it gives a good snapshot of what's going on. Notice the last 4 entries aren't part of the farm per se - they're other machines that are just monitored via this interface.

If anyone needs help setting this up, let me know! It's also flexible enough to be adapted for other Linux distributions.

 

[blakex]

Just thought I'd bump this up since I have made some great new additions to my personal tracker.

I still use an Excel spreadsheet and enter data by hand, but I have automated a lot of the work with some new formulas I learned at work (it actually pays off to be around Excel geeks all day).

And, yes, I know some of these are pretty simple things that I probably should have known, but it's a lot easier now to track my points.

I have 13 columns at the present time:

1: Work Unit Number - just incremented each row.
2: Date - Hard entered.
3: Points - Hard entered points for the work unit completed.
4: Total Points - Quick and easy sum of points.
5: Computer - Hard entered name of computer completing the work unit.
6: CPU WU - Number of work units completed by CPU. I used to hard enter this, but with COUNTIF, it's real easy as it will count how many times the name appears - =COUNTIF($E$2:$E326,$E326).
7: CPU Points - Total number of points output by CPU. I used to hard enter this as well, but a SUMIF works wonders - =SUMIF($E$2:$E326,$E326,$C$2:$C326)
8: RANK - Hard entered rank from Stanford's site.
9: [H] RANK - Hard entered rank in the [H]orde
10: PTS/WU - Total Points / Work Units
11: DAYS - Number of days working on units - used to be hard entered, but apparently, you can just subtract dates and it will output the number of days between the two dates.
12: WU/D - Just total number of work units divided by days working.
13: PPD - Just total number of points divided by days working.

I have also discovered the wonders of conditional formatting (kind of knew about it, but not how powerful it is). I used to manually highlight and border the WU/D or PPD when they set new highs. But you can conditionally format it so if the Cell Value is Greater Than =MAX($M$2:$M325), it will highlight and border. Works like a charm.

So whereas I used to hard enter the date, the points, the computer name, the computer's total WUs, the computer's total Points, and manually shade and border boxes, all I have to enter now is the date, the points and the computer and everything else is done for me. With just 6 computers in house and a thumbdrive to use at work, it's very easy for me to track all my stats and the new automatic calcs work wonders.

Currently:
318 WUs
57,976 Points
Rank: 12,146
[H] Rank: 620
PTS/WU: 182.3
Days Folding: 92
WU/D: 3.46 (high: 3.49)
PPD: 630.2 (high: 646.6)

 

[gnewbury]

Well EMIII will create a .csv file
Why not use that?

 

[rkhands]

Although I am down to only 4 machines (from over 35 at one time ). I use a combination of kdfold and a variation of my folding stats pages to create this: http://www.statsman.info/kdfold/stats

 

[blakex]

Well EMIII will create a .csv file
Why not use that?

I did try that for a few days, but was having problems. Not all completed units were being reported and it was just more hassle than I thought it would be so I'm back to FAHmon which works wonders now that I upgraded.

I also just like to be able to go back and look over past production and past computers and the spreadsheet makes it really easy to see what was going on any one day.

 

[ICE_9]

For those with fold-server boxes, your farm tracks its own progress/PPD. Take a look at ICE_9's page. Nice, no? It doesn't do historical data or make nice graphs, but it gives a good snapshot of what's going on. Notice the last 4 entries aren't part of the farm per se - they're other machines that are just monitored via this interface.

If anyone needs help setting this up, let me know! It's also flexible enough to be adapted for other Linux distributions.

So thats where those hits were coming from. I was begining to wonder if I was just looking at it more often than I realized. The page still works. I have a couple boxen down at the moment but the cool part is if one of the ones connected to the fold server ever has an issue while I am away, I can reboot it through this interface also.

Monitoring, control, reduced parts usage, peace of mind. Fold Server. How do you fold?

 

[gnewbury]

Along this thread - is anyone using qd with anything fancy to pass it to a spreadsheet?
Since Dick Howell passed away smoking2000 is maintaining the code and keeping the protein data updated.
For those that don't know qd dumps the data from the queue and gives info like:

qd released 17 October 2005 (fr 032)
Queue version 5.01
Current index: 7
Index 8: deleted 56.00 pts
server: 171.65.103.149:8080; project: 1706
Folding: run 13, clone 3, generation 7; benchmark 4520; misc: 500, 300
issue: Wed Oct 19 03:23:03 2005; begin: Wed Oct 19 03:23:04 2005
end: ZERO; due: Sat Nov 5 03:23:04 2005 (17 days)
core URL: http://www.stanford.edu/~pande/Win32/x86/Core_78.fah
CPU: 1,87 Pentium IV; OS: 1,8 WinXP
assignment info (le): Wed Oct 19 03:23:01 2005; A1B058FF
CS: 171.65.103.100; P limit: 52427776
user: gemniii; team: 33; ID: 1ACF9B1B58908956; mach ID: 1
work/wudata_08.dat file size: 267144; WU type: Folding@Home

or formatted like:

qd released 17 October 2005 (fr 032)
Queue version 5.01
Current index: 7
- 0AE87898 00000000 -abc.8 1706 13 3 7 4520 56.00 0.000DG
- 0AE8A01A 00000000 -abc.9 245 5 82 84 4520 54.00 0.000DG
- 0AE8A044 0AE95A88 -abc.0 245 5 93 89 4520 54.00 4.077 G
- 0AE95B53 0AEC48C3 -abc.1 1478 1 855 13 7184 364.00 6.830 G
- 0AEC48FE 0AED444A -abc.2 244 1 70 93 6316 63.00 3.525 G
- 0AED446A 0AF069D5 -abc.3 1481 0 714 18 6720 364.00 6.355 G
- 0AF06A10 0AF06FAC -abc.4 2355 0 57 0 7080 0.00 0.000UD
- 0AF06FD8 0AF50864 -abc.5 1481 1 836 7 7080 364.00 4.351 G
- 0AF508A0 0AF5E68B -abc.6 246 0 63 122 6892 53.00 3.359 G
- 0AF5E699 00000001 -abc.7 1911 15 5 13 5460 450.00 9.101RQ "p1911_ALA-depeptide_umbrel"
Average download rate 122.185 KB/s (u=4); upload rate 133.612 KB/s (u=4)
Performance fraction 0.955769 (u=4)
Average pph: 5.458, ppd: 130.99, ppw: 917.0, ppy: 47845