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 ? |
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? |
VBB not spoken here
I even have access to Tecplot - but not the time to master it anyone familiar with it ? |
1 Attachment(s)
Here's an MS-Paint hack job (I didn't complete the right side).
|
Quote:
Bob |
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$) |
Quote:
Bob |
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.
|
|
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 |
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. |
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 :) |
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 ? |
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. |
|
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...