Water Cooling Estimator Spreadsheet

[AndreaBZ]

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

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

* Spreadsheet *
Water Cooling Estimator V.34 2011



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

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

[AndreaBZ]

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



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)



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)


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

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


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

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).


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

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


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

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



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



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

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



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



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

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.



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

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.







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



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

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

[AndreaBZ]

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

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

[AndreaBZ]

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

[AndreaBZ]

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

[AndreaBZ]

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

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

[AndreaBZ]

************************************************** *************************
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....


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

[philbrown23]

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

[Waterlogged]

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

[AndreaBZ]

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

[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!!

[Bojamijams]

Thanks for this Andrea.. and welcome to XS

[XS_RoB]

Looks very interesting - thanks for sharing it with us!

[twwen2]

Thanks Andrea! I'm checking it out now.

[Sadasius]

Wow, nice work!!!

[philbrown23]

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

[voigts]

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

[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 "**"
************************************************** *************************

[AndreaBZ]

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

For Tubing and other ...........

insert : 0 or 1....2.....3.....4.......1,5......1,33 ecc.
NB : 1m = 3,2808 feet

[AndreaBZ]

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

[AndreaBZ]

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.

[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.

!!!!!!!!!
http://www.xtremesystems.org/forums/...d.php?t=206712
et voilá


Thanks

[StAndrew]

Cant download. How do you download this?

[AndreaBZ]

Cant download. How do you download this?

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

[Ashraf]

Cant download. How do you download this?

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