Syntrillium Backup Forums :: View topic - Mid-Side Spreadsheet

Don Brisco · Posted - Wed Jul 16, 2003 9:56 pm

In Excel from A3-A38 use Fill | Series and go from 0 to 350 in steps of 10
(you could use steps of 5 but the graph might get busy). (Note: in a circular graph 0 & 360 are the same position.)

Enter 1 in C1. This is the ratio of S amplitude compared to M i.e. how "wide" you want the stereo image to be. Vary this value from 0 up to say 2.

Enter these labels & formulas in the respective cells:
B2: M(cardioid)
C2: S(fig- Cool

D2: X
E2: Y
B3: =1/(2)*(1+COS(PI()*($A3)/180))
C3: =SIN(PI()*($A3)/180)
D3: =ABS(($B3+($C$1*$C3))/2)
E3: =ABS(($B3-($C$1*$C3))/2)

Note that B3 is a hardwired cardioid response pointing directly forward, i.e. L+R.
that C3 is a hardwired bidirectional, pointing sideways, hence the use of Sine rather than Cos, giving L-R.
D3 is (L+R + L-R)/2 = L.
E3 is (L+R - L-R)/2 = R.

Copy B3:E3 to B4:E38

Highlight D3:E38. Select Chart Wizard | Radar | First Radar graph type (without data points) | Next | Next | select Legend Tab | untick "Show Legend" | Next | Finish.

The graph looks congested because of the 36 category labels (0-350). I delete them by clicking on one of them to select all the Category Labels and then pressed the Delete key. Finally resize and reposition the graph with your mouse.

Brad · Posted - Thu Jul 17, 2003 3:12 pm

Shouldn't this be a "Sticky" post? I mean, how often does this have to be covered?!!

SteveG · Location: United Kingdom

I think that it's hardly worth even considering making anything 'sticky' at the moment - unless you can figure a way to make the entire forum 'sticky'...