Trying to figure out the formula

[Blake0920]

Hi there,

I am trying to crack this formula but cannot seem to figure it out.

Essentially there are three numbers being used, the high, the low, and the close.

H - 4473.00
L - 4415.00
C - 4452.25

To calculate the median you add the H+L+C/3 = 4446.75

I want to use the fibonacci formula to calculate the values. R1,R2,R3 - S1,S2,S3.

R1 = Pivot + 0.382 * (H - L)
R2 = Pivot + 0.618 * (H - L)
R3 = Pivot + 1.000 * (H - L)

S1 = Pivot - 0.382 * (H - L)
S2 = Pivot - 0.618 * (H - L)
S3 = Pivot - 1.000 * (H - L)

Is there a was to reverse engineer how the numbers are calculated above and below the median?

Copy of SupportResistance Calculator.xls
	Q	R	S
88		H - 4473.00
89		L - 4415.00
90		C - 4452.25
91
92		4548.75
93	R2	4515.25
94		4490.25
95	R1	4471.5
96		4457.25
97		4446.75
98		4438
99	S1	4426.25
100		4410.75
101	S2	4390
102		4362.5
Sheet1