Visualizing the pressure around the head
Visualizing the pressure around the head
(OP)
I have measured the pressure between the head and the helmet that arises when wearing a helmet, using pressure sensitive film. The purpose is to see how the pressure is distributed around the head. The film was applied to the head like a sweatband and is divided into a number of sensors that measures the pressure in real time. I have the values stored in an excel document and now I am thinking of ways to have them easily presentable. The sensors are numbered from 0-30 around the head with each sensor having a value in excell. something like this:
# KPa
0 5
1 4
2 10
3 10
.
.
.
29 3
30 8
Is there a way in Excel or some other program that lets you visualize in the following way where the length of the arrows represents the value at that point:
# KPa
0 5
1 4
2 10
3 10
.
.
.
29 3
30 8
Is there a way in Excel or some other program that lets you visualize in the following way where the length of the arrows represents the value at that point:





RE: Visualizing the pressure around the head
EXAMPLE assuming head radius of 1 used:
Sensor #1
Position: +45 deg from horizontal
Tail Position: cos(45deg), sin(45deg)
Head Position: Pressure*(cos(45deg))+cos(45deg), Press*sin(45deg)+sin(45deg)
Not a very elegant solution, but it might work...
Otherwise maybe a 3D graph, again creating a circle for the tail position and the pressure as the "Z" value, but that seems messy and probably not a good way to go...
Or maybe a "radar" graph? I've never used one in Excel, but I see it as an option... Maybe see what you can do with that (again creating a circle head and the pressure).
-- MechEng2005
RE: Visualizing the pressure around the head
So all you need to do is plot the base ellipse, and then draw each arrow.
It'll take you a while to figure out how to do the latter.
There may be a clever solution using Draw commands and VBA to draw some arrows in specified locations.
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Visualizing the pressure around the head
E.g. In my example, X-Axis range goes from 0 degrees to 355 degrees in 5 degree increments. Y-Axis range goes from 0 to 4. Create a Radar Plot, and then change the default scale of the radial axis to shift the Radar Plot out radially.
Hope this helps!
RE: Visualizing the pressure around the head
RE: Visualizing the pressure around the head
Thanks! works great.