Pro/Forums

Pro/Forums (http://forums.procooling.com/vbb/index.php)
-   Water Block Design / Construction (http://forums.procooling.com/vbb/forumdisplay.php?f=37)
-   -   METRIC wb performance curves (http://forums.procooling.com/vbb/showthread.php?t=4390)

BillA 09-14-2002 10:24 PM

METRIC wb performance curves
 
after considerable feedback from the rad article re metric/SI units,
I'm thinking to make the (pending) wb one in SI units
(for those that read graphs) here is an example

for the lowly Cooltech WB75:

http://thermal-management-testing.com/CWpwrWB75.gif

http://thermal-management-testing.com/dietempWB75.gif

http://thermal-management-testing.co...ropWB75kPa.gif

unfortunately, not having grown with these units, I have no 'feel' at all for the magnitudes in this graph

http://thermal-management-testing.co...dropWB75us.gif

while this is just fine (for me)

for all the commentary that has gone on about C vs. F, does the same not apply to liters ?

comments/suggestions ?

bigben2k 09-15-2002 09:25 AM

That's a good question.

I think that what it comes down to, is what's standard, but since your audience is from different countries where the standards are different, it would be best to post results with both standards.

But you don't want to post two graphs showing the same results, so you'd have to come up with a way to use the horizontal scale at the bottom as english measurements, and the top horizontal as metric, and the same for the vertical axes (left: english, right metric). You'd also need a line for the metric measurements with regular cross marks.

The thing is, you'd be hard pressed to trick Excel into doing this.

You need a program that can do that for you. Got any VBB skills?

BillA 09-15-2002 09:35 AM

VBB not spoken here
I even have access to Tecplot - but not the time to master it
anyone familiar with it ?

bigben2k 09-15-2002 09:43 AM

1 Attachment(s)
Here's an MS-Paint hack job (I didn't complete the right side).

utabintarbo 09-15-2002 11:42 AM

Quote:

Originally posted by bigben2k
That's a good question.

I think that what it comes down to, is what's standard, but since your audience is from different countries where the standards are different, it would be best to post results with both standards.

But you don't want to post two graphs showing the same results, so you'd have to come up with a way to use the horizontal scale at the bottom as english measurements, and the top horizontal as metric, and the same for the vertical axes (left: english, right metric). You'd also need a line for the metric measurements with regular cross marks.

The thing is, you'd be hard pressed to trick Excel into doing this.

You need a program that can do that for you. Got any VBB skills?

Actually, I think Excel can do this. Something to look into...

Bob

BillA 09-15-2002 11:50 AM

Bob
really ?
got a 'click' sequence to get into the setup for such ?

(a side note: I am continually impressed with the capabilities of Excel for such a relatively inexpensive program; can't understand all the badmouthing of M$)

utabintarbo 09-15-2002 12:12 PM

Quote:

Originally posted by unregistered
Bob
really ?
got a 'click' sequence to get into the setup for such ?

(a side note: I am continually impressed with the capabilities of Excel for such a relatively inexpensive program; can't understand all the badmouthing of M$)

I know I've seen this done. I can't figure out how to do it right now. It might have been an add-on component. I'll look into it.

Bob

pHaestus 09-15-2002 12:30 PM

If Excel can't do it then a package that I use for work (Microcal Origin) certainly can. It might be pricey for non-academic use; let me see if I have an older version lying around that isn't installed anywhere.

pHaestus 09-15-2002 12:36 PM

http://csssrvr.entnem.ufl.edu/~walke.../06cXLtips.pdf

This may somewhat work.

BillA 09-15-2002 01:09 PM

hummm
close, but no cigar

in a (too ?) quick run-through it seems this (the inst at the top of pg 2) is to superimpose two data sets having different values wrt the y axis
- kill the second dataset and the second scale goes away also;
and no second values can show on the x axis

I really would like to find a way to do this 'natively', as Photoshop (in which I am NOT qualified) always seems to result in image degradation

pHaestus 09-15-2002 01:18 PM

Yes photoshopping I would avoid as well.

The 2 axis link doesn't work if you use two sets of data with the same X axis in both?

Origin is easy. It takes excel spreadsheets as input files so no extra work other than doing the graphing. I would also be happy to reconstruct the graphs for you in that program if you don't want to mess with it.

pHaestus 09-15-2002 01:23 PM

I looked around and it SHOULD be possible in Excel. This book:

http://search.barnesandnoble.com/tex...sbn=0471394629

at least advertises charts with multiple axes in Chapter 5.

Maybe the local Barnes and Noble would have it? A good cup of coffee and a flip through the book wouldn't be so awful on a Sunday. I used to solve specific php coding issues that way :)

BillA 09-15-2002 01:31 PM

there are so many graphs - tolerable,
with SO many revisions - really intolerable (but also quite necessary for GOOD results);
don't wish to lose that welcome mat

but thanks

raining pitchforks and hammer handles right now, I'll try to hit B&N next week

origin ?

pHaestus 09-15-2002 01:33 PM

hrm the Excel help pulled up this:

"Add a second axis
When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.

Click the data series you want to plot along a secondary value axis.
On the Format menu, click Selected Data Series, and then click the Axis tab.
Click Secondary axis."

I suspect you've tried this with 2 sets of data (one metric and one english) already though.

utabintarbo 09-16-2002 10:37 AM

You can also check this MS KB link:

http://support.microsoft.com/default...;en-us;Q214011

Bob


All times are GMT -5. The time now is 09:30 AM.

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
(C) 2005 ProCooling.com
If we in some way offend you, insult you or your people, screw your mom, beat up your dad, or poop on your porch... we're sorry... we were probably really drunk...
Oh and dont steal our content bitches! Don't give us a reason to pee in your open car window this summer...