Water Cooling Estimator Spreadsheet

************************************************** *************************
http://www.pctunerup.com/up/results/...ne-tj07-10.jpg
************************************************** *************************

* Spreadsheet *
Water Cooling Estimator V.34 2011

http://www.pctunerup.com/up/results/...07232542_x.jpg

Download Last Update : V. 34 2011

http://www.coolingtechnique.com/down...andrea-22.html

************************************************** *************************
* Spreadsheet *
Comparative analysis of the Fans
By Matrtin Lab

http://www.xtremesystems.org/forums/...d.php?t=261778

Download Last Update :

http://www.coolingtechnique.com/inde...=84&Itemid=124

************************************************** *************************

Instructions for the use (LAST UPDATE : 01 2010):

The last line there are various sheets:
Interface------Flow Rate----Rad RPM>TEMP----RAD RPM>WATT----RAD WATT>TEMP
WB__C°/W > Flow Rate ---- WB in Sys A and WB in Sys B.


************************************************** *************************
Interface :
Configure the System A and System B

http://www.pctunerup.com/up/results/...07232542_x.jpg

Manually insert :
temperatura ambiente C° = room temperature C°= temperature air in Radiator
Watt RAD. = Watt absorbed by Radiator = Heat Dissipated (in Watt)
coeff.*Watt CPU = coefficient considers: Watt absorbed by WB CPU + (Tim C°/W) + system of measuring the temperature)
Fan.Speed = RPM fans (menu)

http://www.pctunerup.com/up/results/...07232736_x.jpg

To calculate the Watt CPU and radiator:

http://www.extreme.outervision.com/tools.jsp#cpuoc
http://extreme.outervision.com/psucalculatorlite.jsp
http://web.aanet.com.au/SnooP/psucalc.php

Selection unit of measurement (menu)
http://www.pctunerup.com/up/results/...07232953_x.jpg

************************************************** *************************

Choose the various components from menu for the system A and B:

http://www.pctunerup.com/up/results/...233312_xxx.jpg
************************************************** *************************

Appears:
Flow rate of systems A and B
Difference Temp. Air > H2O (Delta temp.between temp.h2o and room temp.)
Difference Temp. H2O > CPU (Delta temp. between temp. Core CPU and temp.h2o)
Temp. CPU (temperature core CPU).

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg
************************************************** *************************

Flow Rate
the chart shows the flow rate of the systems A and B:

http://www.pctunerup.com/up/results/...4208_xxxxx.jpg http://www.pctunerup.com/up/results/...301_xxxxxx.jpg
************************************************** *************************

RAD RPM>TEMP
The chart shows : Delta T. (temp h2O-room temperature) in function of the fans rpm.

http://www.pctunerup.com/up/results/...5_xxxxxxxx.jpg http://www.pctunerup.com/up/results/..._xxxxxxxxx.jpg

the sum RAD 1+2 of system A
and the sum RAD 1+2 of system B.

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

************************************************** *************************

RAD RPM>WATT
The chart shows :Heat Dissipated for a 1C° and 10C°
Water (IN+OUT Average) -Air (IN Average) > RPM

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

RAD WATT > TEMP
The chart shows :Heat Dissipated (WATT) > Water (IN+OUT Average) -Air (IN Average)

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

************************************************** *************************

WB__C°/W > Flow rate > Temp
The chart shows WB C°/W (tuermal resirtance) in function of flow rate.
WB CPU of system A and WB CPU of sytem B.

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

************************************************** *************************

WB in Sys A: and WB in Sys B:
The chart shows the data of all the WB of spreadsheet
"fed" by the pump selected in the system to or in the system B
A comparison between all the WB.

http://www.pctunerup.com/up/results/...19184337_x.jpg

http://www.pctunerup.com/up/results/...9184423_xx.jpg

http://www.pctunerup.com/up/results/...184513_xxx.jpg

************************************************** *************************



Data source :

MLL = Martin's Liquid Lab data
http://martin.skinneelabs.com/
Cpu block Marked (MLL) = Martin's Liquid Lab
- Intel Core Q6600 @3600 1,47V

HES = HESmelaugh
http://www.dexgo.com/index.php?site=...ardware&id=378
Cpu block Marked (HES) = HESmelaugh
http://www.xtremesystems.org/forums/...d.php?t=224976
- Intel Core i7 920 @ 3.7GHz, 1.28V

Cpu block Marked (**) = Other sources from the Web
- Intel Core i7

************************************************** *************************

************************************************** *************************

************************************************** *************************

************************************************** *************************
************************************************** *************************

************************************************** *************************
************************************************** *************************

************************************************** *************************

************************************************** *************************

************************************************** *************************
change the fans
Thanks to the study of Martin.
http://www.xtremesystems.org/forums/...d.php?t=223391
It is possible to change the fans....

http://www.pctunerup.com/up/results/...18_xxxxxxx.jpg
************************************************** *************************

thanks! I'll post up mine asap!
EDIT: very slow download :(

Looks pretty nice but, it didn't need 7 posts, that's called spamming. ;)

************************************************** *************************
The "Coeff.* Watt CPU"
http://www.xtremesystems.org/forums/...0&postcount=41
************************************************** *************************

Awesome work!

I havn't figured out how it all works, but I'm having fun!

Thanks for putting all the work into this!!

Thanks for this Andrea.. and welcome to XS :D

Looks very interesting - thanks for sharing it with us! :)

Thanks Andrea! I'm checking it out now.

Wow, nice work!!!

so im confused with it, I cant cange my tubing and other various settings, why?

A lot of good info, but the interface is kind of confusing. Keep up the good work!

************************************************** *************************
Theory, to me, on mathematical extrapolation of the data on the efficiency of radiators.
Consider the structure of 2 radiators identical.
The surface of the radiators and the number (size) of the fans different .

Mathematical formula for radiators (same structure):
C°/W A = thermal resistance of the radiator with 3 fans ........ height of surface rad.A= hA
C°/W B = thermal resistance of the radiator with 2 fans ........height of surface rad.B= hB
formula:
C°/W B = C°/W A*(((3fans/2fans)+(hA/hB))/2) = C°W A*(((2/3)+(hA/hB))/2)
C°/W A = C°/W B*(((2fans/3fans)+(hB/hB))/2) = C°W A*(((3/2)+(hB/hA))/2)


************************************************** *************************
In spreadsheet the radiators calculated mathematically are listed with 2 asterisks "**"
************************************************** *************************

Quote:

---

Originally Posted by philbrown23

so im confused with it, I cant cange my tubing and other various settings, why?

---

For Tubing and other ...........
http://www.pctunerup.com/up/results/..._xxxcxxxxx.jpg
insert : 0 or 1....2.....3.....4.......1,5......1,33 ecc.
NB : 1m = 3,2808 feet :)

Quote:

---

Originally Posted by voigts

A lot of good info, but the interface is kind of confusing. Keep up the good work!

---

It is simple to shape.
It is a lot similar to Martin's spreadsheet :)

Quote:

---

Originally Posted by Martinm210

Awesome work!

I havn't figured out how it all works, but I'm having fun!

Thanks for putting all the work into this!!

---

Hello Martin! :)
The data I miss suits (Pressure drop vs flow rate) of WB Swiftech GTZ.
Please,if you have them,give them for me.

Quote:

---

Originally Posted by AndreaBZ

Hello Martin! :)
The data I miss suits (Pressure drop vs flow rate) of WB Swiftech GTZ.
Please,if you have them,give them for me.

---

!!!!!!!!! :D
http://www.xtremesystems.org/forums/...d.php?t=206712
et voilá:D
http://www.pctunerup.com/up/results/...xxxcxxxxxx.jpg

Thanks

Cant download. How do you download this?

Quote:

---

Originally Posted by StAndrew

Cant download. How do you download this?

---

http://www.xtremesystems.org/forums/...00&postcount=1

Quote:

---

Originally Posted by StAndrew

Cant download. How do you download this?

---

I uploaded it for you. Here: http://royalsrealm.net/downloads/Andrea_V8x.zip

thanks mod with arabic name...shukran Allah be with you

It's Italian:ROTF:

Very nice spreadsheet, I especially like that there are different values compared to who tested them.

System measurement of the temperatures
used by Nextharware liquid lab
http://www.nexthardware.com/recensio...da/111_853.htm

http://www.pctunerup.com/up/results/...7122809_XX.jpg

Very nice spreadsheet. Thanks for the work. You are awesome.

Update .... New Spreadsheet V.11

http://ultrashare.net/hosting/fl/db6...8/Andrea_V11xp

The equations of the WB and of the radiators were perfected.
It is possible to push itself, with reliable results, beyond the 5 GPM of flow rate and beyond 10000 RPM.
They were introduced these new radiators marked **

XSPC RS120 **
Feser X-Changer 240 **
Feser X-Changer 120 **
Thermochill PA 120.4 **(There is in reality):D
Thermochill PA 120.2 **
Thermochill PA 120.1 **
Swiftech MCR 120 **
HW Labs 360 GTX **
HW Labs 240 GTX**
HW Labs 120 GTX **
Hw Labs GT Stealth 240 **
Hw Labs GT Stealth 120 **
Hw Labs GT Stealth 280**
Hw Labs GT Stealth 140 **

The data are obtained with mathematical extrapolations (**)

************************************************** *************************
************************************************** *************************

************************************************** *************************

************************************************** *************************

************************************************** *************************

I love you, please have my babies.

Quote:

---

Originally Posted by Salad Fingers

I love you, please have my babies.

---

I don't remember posting that.
Must of been seriously smashed.

shouldnt this be a sticky?

Spreadsheet V. 2.00 2009!!
************************************************** *************************
Download in the first page!

Can this be easily modified for Triple-SLi and more than 2 rads? (up to 4?)

Trying to run a few comparisons, separate GPU loop vrs not, and get some issues removing the CPU block, for example... I'll play with it a bit more after work.

Wow, nice work!!

would like to see HD4870 waterblocks?

************************************************** *************************
The "Coeff.* Watt CPU"

http://www.pctunerup.com/up/results/...16144959_x.jpg

To make uniform the data of two " Tester "
and to compare them among them.

A small formula mathematics is necessary.

We consider two " Tester ": A and B.

The two " Tester " measure the difference of temperature among Core CPU
and H20 of 4 WB: (WB1 WB2 WB3 and WB4).

We have that:

T.A.WB1 (temperature measured by tester A for the WB1)
T.A.WB2...... .T.A.WB3...... ..T.A.WB4
and
T.B.WB1 (temperature measured by tester B for the WB1)
T.B.WB2...... .T.B.WB3...... ..T.B.WB4

To the same Flow Rate have.......
Mathematics formula :
(T.A.WB1/T.B.WB1)=(T.A.WB2/T.B.WB2)=(T.A.WB3/T.B.WB3)=(T.A.WB4/T.B.WB4)

The relationships of the temperatures are equal to a constant K.

Calculated K......... it is easy to transform all the temperatures in (A tester temperatures)
or (B tester temperatures)

************************************************** *************************

Any plans for adding additional radiator options?

Quote:

---

Originally Posted by warriorpoet

Any plans for adding additional radiator options?

---

Three radiators?
It seems to me excessive.
To modify the Spreadsheet to insert three radiators
it is simple for the flow rate
it is complicated for the temperatures.
Which are the radiators?
It is more soldier to insert a new radiator corresponding to the sum of others two
If you tell me what radiators I can make a revision of the spreadsheet. :D

Quote:

---

Originally Posted by maddoggy

Can this be easily modified for Triple-SLi and more than 2 rads? (up to 4?)

Trying to run a few comparisons, separate GPU loop vrs not, and get some issues removing the CPU block, for example... I'll play with it a bit more after work.

---

You see answer above :D

andreabz i've been reading the coeff*watt info..i can't figure it out exactly...

say my i920 is 300w and i'm using the ek supreme,,, what should i put in the coeff*watt?

wattage to the rad is total watts in the loop right?

excellent work:up:

Could you add GPU temp?

ADDED: Your spreadsheet doesn't seem to take flow into account when calculating radiator performance. Could you fix it?

Quote:

---

Originally Posted by m^2

Could you add GPU temp?

ADDED: Your spreadsheet doesn't seem to take flow into account when calculating radiator performance. Could you fix it?

---

The data published are too much little.

.................................................. .............

You are right.
Unfortunately the " testers " don't furnish data
on the variation of the thermal resistance of the radiators to vary some flow rate.

The only information until furnished by Thermochill.........
http://www.thermochill.com/PATesting/index.php#PA1202

http://www.pctunerup.com/up/results/...lowrateGPM.jpg

it don't give numerical data.
The variation between 1.0 GPM and 2.0 GPM is really least.
In the next version of the spreadsheet i could impose
a similar equal variation for all the radiators.
Does it seem to you correct?

This problem also concerns the Water Block.
Only "Next Hardware" furnishes data on the variation of the thermal resistance of the WB to vary some flow rate.
To calculate the variation of the thermal resistance of the WB tested by "Martin = MLL"
i have used an artifice:
a curve that is the average of the curves of the WBs tested by "Next Hardware".


I have used an software of translation Italian> English.....
I hope that you can understand.

Quote:

---

Originally Posted by Hondacity

andreabz i've been reading the coeff*watt info..i can't figure it out exactly...

say my i920 is 300w and i'm using the ek supreme,,, what should i put in the coeff*watt?

wattage to the rad is total watts in the loop right?

excellent work:up:

---

The Spreadsheet doesn't point out the exact temperature of the CPU,
but it calculates the difference of temperature among a system and another,
between a component and another.
If you want that the Spreadsheet points out the same temperature that points out your PC
with core temp............
1.... to exactly point out temperature of the room,RPM fans and watt radiator.
(yes...... .wattage to the rad is total watts in the loop)
2.... to check that temperature points out core temp with the cpu in full load
3.....to modify coeff*Watt cpu so that the spreadsheet points out the same temperature
pointed out by core temp.

Or ,if you have a thermometer to measure the temperature of the water.
You calculate difference among temperature cpu and temperature of the room
modifying coeff*Watt CPU you do it coincide with ______ CPU_______ C°/W*Watt
what you read aloft to the right

************************************************** *

http://www.pctunerup.com/up/results/...ne-tj07-10.jpg


Andrea, very good work on the spreadsheet and testing:clap:
What is the water block in the above picture?

Thank you.........
Unfortunately I do not know.

Spreadsheet V.4.00 2009!!
************************************************** *************************

We have included almost all the Pump tested by Skinnee Labs (SKL).
The radiators XSPC RX 120 (SKL)
Pump Iwaki RD30 24V ! tested by Martinn's Liquid Labs (MLL)
WB Enzotech Luna Rev.A tested by Nexthardware (NEX)
......... And more


Push Pull in the Spreadsheet

http://www.pctunerup.com/up/results/...21013638_x.jpghttp://www.pctunerup.com/up/results/...1014353_xx.jpg

http://www.pctunerup.com/up/results/...013055_xxx.jpg http://www.pctunerup.com/up/results/...13123_xxxx.jpg

Download V.4.00 2009 in the first page!


************************************************** *************************

andreabz

you're work is great,

I've been testing the core7 particularly the 940...and its hot...been also observing power drawn when i'm running occt or prime95..here's a screenshot..

at idle(connected to my ups the kil-a-watt >psu>mobo cpu ram and raptor no fans or pump connected)
http://i24.photobucket.com/albums/c5...5/image003.jpg
at load
http://i24.photobucket.com/albums/c5...5/image001.jpg

My question regarding the spreadsheet, With everything in its place, if I set my temperatures to say 60C with known components(cpu +cpu waterblock +pump +radiator etc), can we calculate how much total heat in terms of wattage that my cpu is producing?

so far intel's tdp is very good..i've had e8600 a q9550..and both are in the 50-150w range...but this core i7 is a beast...as shown in my pics...but thats power from the wall...computing for power supply load....i'd assume 80%..

but i only have one question with the spreadsheet.. if i change the cpu temperature can we reverse calculate the heat load..in terms of wattage?

Quote:

---

Originally Posted by Hondacity

andreabz

you're work is great,

I've been testing the core7 particularly the 940...and its hot...been also observing power drawn when i'm running occt or prime95..here's a screenshot..

at idle(connected to my ups the kil-a-watt >psu>mobo cpu ram and raptor no fans or pump connected)
---
at load
--
My question regarding the spreadsheet, With everything in its place, if I set my temperatures to say 60C with known components(cpu +cpu waterblock +pump +radiator etc), can we calculate how much total heat in terms of wattage that my cpu is producing?

so far intel's tdp is very good..i've had e8600 a q9550..and both are in the 50-150w range...but this core i7 is a beast...as shown in my pics...but thats power from the wall...computing for power supply load....i'd assume 80%..

but i only have one question with the spreadsheet.. if i change the cpu temperature can we reverse calculate the heat load..in terms of wattage?

---

http://www.pctunerup.com/up/results/...xcoeff-01x.jpg

The "Coeff.* Watt CPU"
Are not the watts products by the CPU But (watt * a coefficient "k")
About this I wrote this article :

http://www.xtremesystems.org/forums/...0&postcount=41

Therefore it is not possible to calculate with the Spreadsheet the watts products by the CPU.
-------------------

eurika!!! thanks for the link...i finally have a grasp on the coeficient "k"

:up:

the total flow is not correct when adding a second radiator...

pls have a look, thanks

Year I had an issue when adding another rad, flow would not change at all.

And if possible I would like to see a 3. rad option :)

Quote:

---

Originally Posted by Hondacity

the total flow is not correct when adding a second radiator...

pls have a look, thanks

---

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

you are right!
!!!!!!!!! :D
happens in the last version.
system immediately.:D
Thank you for an.

Correct version :

http://ultrashare.net/hosting/fl/c1b...ea_V-4.01-2009

................... is OK ?

Between a little comes the version 5
Equations flow rate vs. pressure drop improved , refined.
Perhaps the radiators XSPC RX series tested by skinne labs.
You have tried to verify if my formula push pull is correct ?

Thanks for your collaboration.

Spreadsheet V.5.00 2009
coming soon

I have inserted in the spreadsheet the radiators Swiftech MCR320, ThermoChill PA120.3, XSPC RX360

Spreadsheet V. 5.01 2009
Download available in the first page.

************************************************** ******************************

What is it the:
Watt Radiatore 300
Means?

Quote:

---

Originally Posted by Mech0z

What is it the:
Watt Radiatore 300
Means?

---

300 is heat load in watts from radiator
= watt CPU + watt VGA + watt pump (10 - 20 watt)
+ watt chipset mainboard NB SB and mosfet every 30 watt .

Quote:

---

Originally Posted by AndreaBZ

300 is heat load in watts from radiator
= watt CPU + watt VGA + watt pump (10 - 20 watt)
+ watt chipset mainboard NB SB and mosfet every 30 watt .

---

So its the total watt load on the radiator? Or is the CPU watt taken from the Coeff.* Watt CPU

the total watt load on the radiator:D

Coeff.* Watt CPU is watt CPU * a Coefficient whic may be more or less of 1.
The coefficient is needed to make uniform and comparable data of the various "tester".
Practically...To read in spreadsheet the same temperatures that indicates "core temp".

Quote:

---

Originally Posted by AndreaBZ

************************************************** *************************
Theory, to me, on mathematical extrapolation of the data on the efficiency of radiators.
Consider the structure of 2 radiators identical.
The surface of the radiators and the number (size) of the fans different .

Mathematical formula for radiators (same structure):
C°/W A = thermal resistance of the radiator with 3 fans ........ height of surface rad.A= hA
C°/W B = thermal resistance of the radiator with 2 fans ........height of surface rad.B= hB
formula:
C°/W B = C°/W A*(((3fans/2fans)+(hA/hB))/2) = C°W A*(((2/3)+(hA/hB))/2)
C°/W A = C°/W B*(((2fans/3fans)+(hB/hB))/2) = C°W A*(((3/2)+(hB/hA))/2)


************************************************** *************************
In spreadsheet the radiators calculated mathematically are listed with 2 asterisks "**"
************************************************** *************************

Some examples:

This the chart of the radiators
Swiftech MCR 320 MLL e Swiftech MCR 220 MLL (Tested by Martin):

http://www.pctunerup.com/up/results/...xxxxxxvxxx.jpg

This the chart of the radiators
Swiftech MCR 320 MLL and Swiftech MCR 220** extrapolated from the radiator Swiftech MCR 320 MLL

http://www.pctunerup.com/up/results/...xxxxvxxxxx.jpg

This finally the chart of the radiators
Swiftech MCR 220 MLL and Swiftech MCR 220** extrapolated from the radiator Swiftech MCR 320 MLL

http://www.pctunerup.com/up/results/...xxxxxvxxxx.jpg
Seem coincidental .
************************************************** *************************
Still. ............
XSPC RS 240 MLL and XSPC RS 240 ** extrapolated from the radiator XSPC RS 360 MLL
http://www.pctunerup.com/up/results/...xxxvxxxxxx.jpg
Too these almost coinciding.
************************************************** *************************
Another example of extrapolated data........
This the chart of radiators:
Feser X-Changer 480 MLL
Feser X-Changer 480 Next
http://www.pctunerup.com/up/results/...0164117_xx.jpg

This the chart of the radiator:
Feser X-Changer 480**extrapolated from radiator:Feser X-Changer 360 Next
http://www.pctunerup.com/up/results/...4444_xxxxx.jpg
This the chart of radiators:
Feser X-Changer 480 Next
Feser X-Changer 480** (extrapolated)
http://www.pctunerup.com/up/results/...164636_xxx.jpg
.....very similar.

This the chart of radiators:
Feser X-Changer 480 MLL
Feser X-Changer 480** (extrapolated)
http://www.pctunerup.com/up/results/...64749_xxxx.jpg
Practically the same!
A further demonstration of validity of "extrapolated data".
************************************************** *************************
In this example instead .........XSPC RS 120 MLL and XSPC RS 120 ** extrapolated from the radiator XSPC RS 240 MLL
http://www.pctunerup.com/up/results/...xxvxxxxxxx.jpg

Are not coincidental.
In my opinion it is preferable the chart extracted from the data extrapolated mathematically,
preferable to that which is obtained from measurements of Martin Liquid Lab (MLL).
............
This is the chart of three radiators XSPC tested by Martin (MLL)
and of the radiator XSPC 120 ** "extrapolated" from the data of the radiator XSPC 240 MLL.
http://www.pctunerup.com/up/results/...8183354_xx.jpg
To it seems me that the chart of the radiator XSPC 120 ** "extrapolated" is more in line with the other 2.
The chart of the radiator XSPC 120 ** "extrapolated" is more realistic.
************************************************** *************************

---

This is correct as a first order interpolation given what radiators do. The actual formula for radiators is something called Log mean temperature differentail. Which would say that the water entering the last fan of a 3 fan radiator is actually cooler so will have less heat transfered away from it.

Look at the wikipedia entry for crossflow heat exchangers as an example
http://en.wikipedia.org/wiki/Heat_exchanger

Compact heat exchangers by Kays and landon is the holy bible on this subject despite it being from the 50's there are some newer computational methods being developed though
http://www.amazon.com/Compact-Heat-E.../dp/1575240602


Me and bill A and then martin had an argument about this your approximation is good because if you don't do this it is hard to model in excel without a good equation solver.

With available equipment and temperature differentails in the water cooling scene it is impossible to calculate anything accurately as the test data is not 100% right.

***************


Unfortunately "Babylon" the translation software that i use gave me a text almost incomprehensible.


For the radiators I use a formula for the type .........Y = a*X^n with n < 0 and > -1 .

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

I think the same used by Martin.

Is a function easily manageable with Excel and, to me, quite correctly describes the phenomenon physical.

According to me , it is very valid if the difference between the water temperature and
the ambient temperature is not too high.

The data extrapolated in this way provide data very similar to the data measured.

I have given above some examples.

The difference is of two tenths of a degree in the cases more unfavourable.

Of course this is a nearest,depends on the accuracy of formula and the accuracy of data from extrapolate.

Another example of extrapolation:
Fans in push pull mode .......

This is a chart published by Martin

http://www.pctunerup.com/up/results/...3-38mm2000.jpg

I indicated the two temperatures interesting.

This is the formula I have published long ago :

http://www.xtremesystems.org/forums/...19&postcount=6

************************************************** *************************
Radiators with fans in push pull

**************
See :
Mathematical extrapolation of the data on the efficiency of radiators.

http://www.xtremesystems.org/forums/...0&postcount=32



Consider the structure of 2 radiators identical.
The surface of the radiators and the number of the fans different .

Mathematical formula for radiators (same structure):
C°/W A = thermal resistance of the radiator with 3 fans ........ height of surface rad.A= hA
C°/W B = thermal resistance of the radiator with 2 fans .........height of surface rad.B= hB
formula:
C°/W B = C°/W A*(((3fans/2fans)+(hA/hB))/2) = C°W A*(((2/3)+(hA/hB))/2)
C°/W A = C°/W B*(((2fans/3fans)+(hB/hB))/2) = C°W B*(((3/2)+(hB/hA))/2)

Analogously ..............

Push Pull .........
The structure of 2 radiators : identical
The surface of the radiators : identical
The number of the fans = X*2

Mathematical formula for radiators (same structure):
C°/W A = thermal resistance of the radiator with X*2 fans ....... height of surface = h
C°/W B = thermal resistance of the radiator with X fans .........height of surface = h

formula:

C°/W A = C°/W B*(((Xfans/X*2fans) + (h/h))/2)
= C°/W B*((( 1/2) + (1))/2)
= C°/W B*(0.5+1)/2
= C°/W B*0,75

C°/W A = C°/W B*0,75



....... 10,1° * 0,75 = 7,575°........very similar to the data published by Martin.


Is always pleasant and interesting exchange views on this mysterious world.
......

You may want to read this. Hopefully the many postings will clarify what is talked about...

http://forums.procooling.com/vbb/showthread.php?t=12306

Great work you are doing here Andrea ;)

Mate i can't seem to get this spreadsheet from the links provided, anychance of a new link? Also hows the Spreadsheet V.5.00 version coming along?

Az

Quote:

---

Originally Posted by azza21

Mate i can't seem to get this spreadsheet from the links provided, anychance of a new link? Also hows the Spreadsheet V.5.00 version coming along?

Az

---

New link In the first page

************************************************** *************************

************************************************** *************************

Do you think it would be possible to use the data from martins fantesting to be able to pick which fans your using and then see how much difference there is between each fan. That would be super sweet, and you would proberly only have to add the most popular ones

Quote:

---

Originally Posted by Mech0z

Do you think it would be possible to use the data from martins fantesting to be able to pick which fans your using and then see how much difference there is between each fan. That would be super sweet, and you would proberly only have to add the most popular ones

---

I am working :D
A preview .......
http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

I wait for the test of Skinnee on the radiator feser X changer

Then the update of the spreadsheet arrives :up:

*************************************************

NICE :) this will make it much easier to find out which part is the best/cheapest way to lower your temps

GJ AndreaBZ

Spreadsheet beta test :D

It begins to work......... :up:

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

************************************************** *************************

************************************************** *************************
New update Spreadsheet !

http://www.pctunerup.com/up/results/...4165345_xx.jpg

New disposition

http://www.pctunerup.com/up/results/...165422_xxx.jpg

RPM of the fans separated for the two systems...

http://www.pctunerup.com/up/results/...5538_xxxxx.jpg

Thanks to the study of Martin.
http://www.xtremesystems.org/forums/...d.php?t=223391
It is possible to change the fans....

http://www.pctunerup.com/up/results/...18_xxxxxxx.jpg

Gentle Typhoon > Nanoxia FX 2000

http://www.pctunerup.com/up/results/..._xxxxxxxxx.jpg

3 new WBs marked HES
http://www.dexgo.com/index.php?site=...ardware&id=378

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

I have improved the Equations of the flow rate.
Now the spreadsheet is more precise :D

************************************************** *************************

Water Cooling Estimator Spreadsheet V.6.00 2009 Download :
http://www.coolingtechnique.com/down...andrea-22.html

************************************************** *************************

Quote:

---

Originally Posted by AndreaBZ

************************************************** *************************

Water Cooling Estimator Spreadsheet V.6.00 2009 Download :
http://www.coolingtechnique.com/down...andrea-22.html

************************************************** *************************

---

Very solid work :up: and I suppose the more tests results the more precise this will become :)

I have corrected an error :rolleyes:
it concerns the WBs marked * HES:D

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

v.6.01 download ... in the first page

The calculator seems to malfunction when I chose the GTS rads, something about a negative value somewhere.

Quote:

---

Originally Posted by silverphoenix

The calculator seems to malfunction when I chose the GTS rads, something about a negative value somewhere.

---

:rofl:

Sounds about right. :ROTF:;)

Sorry, I had to because I'm still pissed about being suckered in and buying mine.

well weird I got it to work now, in any case I don't know the MCR320 is beating out the GTS360 all the way up to 2400rpm, while HesMelaugh's tests as well as the french test say other wise.

Quote:

---

Originally Posted by silverphoenix

well weird I got it to work now, in any case I don't know the MCR320 is beating out the GTS360 all the way up to 2400rpm, while HesMelaugh's tests as well as the french test say other wise.

---

You got to remember that he can only work with the data he has, and from what I know, not many have reviewed the GTS rad and if the data gathering is not as precise as it have been in Martins or HES tests, then he cant calculate the precise performance, but if more review it then he can get more accurate data into this lovely spreadsheet which seems to get better and better :up:

Quote:

---

Originally Posted by silverphoenix

The calculator seems to malfunction when I chose the GTS rads, something about a negative value somewhere.

---

http://www.pctunerup.com/up/results/...xxxxxxxxxx.jpg

GTS rad works only with "Martin Lab Fans":D
don't exist data on the fans of the test.
And it is not precise as the other radiators.

****************

UPDATE

New Chart (Rad RPM > Watt)
RPM > Heat Dissipated for a 1C°and 10C° Water (IN+OUT Average) -Air (IN Average)

http://www.pctunerup.com/up/results/...18160626_x.jpg

Formula Push Pull improved is more precise now ...........

The old formula considered (Push Pull = Fans x 2)
http://www.xtremesystems.org/forums/...19&postcount=6
The new formula considers (Push Pull = CFM x2)
It is mathematically more complicated.
Example:
This is the equation of the radiator Thermochil pa 120.3
Temp.=8,31*RPM^-0,86
This is the equation of the radiator Thermochil pa 120.3 Push Pull
Temp.=8,31*(1,4142^-0,86)*RPM^-0,86.

practically....
With the old formula:
temp push pull = 0,75 temp no push pull
With the new formula:
temp push pull = 0,742242981 temp no push pull
In this case the difference among the two formulas is least.
With other radiators he can be great.

To calculate the equation of the trend line RPM CFM of the fan Triebewerk TK 122


Feser TFC Monsta 360-420 tested by Martin

http://www.xtremesystems.org/forums/...d.php?t=226618

Scythe Ultra Kaze 3000 and Triebewerk TK 122
Equation of the trend line RPM > C°/W

http://www.pctunerup.com/up/results/...20155945_x.jpg

Equation of the trend line CFM > C°/W
http://www.pctunerup.com/up/results/...0160156_xx.jpg

************************************************** *************************

http://www.pctunerup.com/up/results/...160307_xxx.jpg http://www.pctunerup.com/up/results/...60349_xxxx.jpg

************************************************** *************************

http://www.pctunerup.com/up/results/...2257_xxxxx.jpg

************************************************** *************************

Thanks for your efforts on this AndreaBZ. Being a long time excel geek, I can appreciate all the effort you have put in to make this spreadsheet as complete and expandable as possible.

Cheers!

Update : V.7.00 2009
Ybris ACS-G and Ybris Eclipse GPU
Tested by Oreste (Italy)
http://www.coolingtechnique.com/rece...eclipse-g.html

Download in the first page

************************************************** *************************

i love the unit conversion :D

Thank you so much for keeping this idea alive. It is such a useful tool.

************************************************** *************************
UPDATE ! V. 9.01.2009
Download in the first page :D
************************************************** *************************

Fans Spreadsheet
**********
1) Fans tested by Martin's Liquid Labs
http://www.xtremesystems.org/forums/...d.php?t=223391

CFM ....resistance to the air : (radiator XSPC RS120)
**********
2) Fans tested by CT Labs
http://www.coolingtechnique.com/rece...e-rheobus.html

CFM ....resistance to the air : (open air)

db and pressure .........
http://translate.googleusercontent.c...UJLTu4ORGGKguA


http://www.pctunerup.com/up/results/...234152_yyy.jpg http://www.pctunerup.com/up/results/...34232_yyyy.jpg


http://www.pctunerup.com/up/results/...3234353_yy.jpg

Download in the first page :D

Please keep it coming Andrea. This is an excellent tool.

andreaBZ

please include vapors cpu block testing..i wanna see how his testing fare with martins

thanks

Quote:

---

Originally Posted by Hondacity

andreaBZ

please include vapors cpu block testing..i wanna see how his testing fare with martins

thanks

---

************************************************** *************************

************************************************** *************************