There is a very interesting thread in the chat group regarding a "New stats program".
Although the thread is a year old I just discovered it.
If you use Excel to track results this may be of interest to you and I recommend that you read the thread.
http://www.worldcommunitygrid.org/forums/wcg/viewthread_thread,31060

Excel spreadsheets and converting run time.

I wanted to convert the run time into an integer as is done in my signature.
My run time was 20:347:20:1:18 which converted to 660772878 seconds.
To convert seconds to integer years I divided the number of seconds by the number of projects(20),
and the result divided by the number of seconds in a year.
660772878/20 = 33038643.9
33038643.9/31536000 = 1.05 = run time / project

To verify that my spreadsheet had no errors I wanted to convert from seconds to 20:347:20:1:18 format.
So, I converted 660772878 seconds back to years, days, hours, minutes, and seconds and put them in adjacent cells.
The cells were then joined and delimited with colons.
Three formulas were used:

=TRUNC(O4) truncated the numbers to whole numbers and discarded any remainder.

=MOD(Q4,$H$2) modulo gave me the remainder and discarded the whole number.

=CONCATENATE(AG4,":",AH4,":",AI4,":",AJ4,":",AK4) gave me the string with colons 20:347:20:1:18

I hope this helps someone.

I understand your feelings, rcc
I think you should try to let go of it and refer to your motto in your signature - my favorite Facebook Filosofi
- as you may have seen in my replies, it is difficult to handle, because:
To get mad at the right person
to the right degree
for the right reason
at the right time
is an art form
I Only Have Eyes for You

Sunfolk,

There are several coolants that are not too expensive on the market. Feser One, PrimoChill PC ICE, and Fluid XP + Extreme. They all claim to be non-conductive as long as they are not mixed with other fluids and as long as they are kept dust and dirt free.

Burno

Getting good advice from other members.
My complaint is not that there are trolls in forums, but that once they enter a thread it is poisoned and it becomes impossible to get a fair question answered.
I am not a turnip that fell off of the truck yesterday.
I have been on WCG since 2007 and before that United Devices going back many years (Remember LigandFit?).
Also spent a lot of time on Usenet in the cancer groups trying to learn more about my cancer.
Usenet became Uselessnet because of the trolls.
Just the other day I was thinking how nice it is to have forums at WCG that do not contain angry little people that destroy the usefulness of the forum.
And then I asked a question on another forum and got hammered by someone.
One kind member answered my question.
One unkind member told me I was only allowed to post ideas, not criticism.
It was a question not a criticism.
It poisoned the experience for me.
Then I read a thread where this same unkind member mistreated little mermaid because she asked a question.
Then I came across a thread where this same unkind member tore into nasher for asking a question.
There is a pattern there.
Asking a question will get you attacked.
That is nonsense.
I find that unacceptable.
You may read my comments on this at https://secure.worldcommunitygrid.org/forums/...8_lastpage,yes - lastpost