Spectre A

Spectre B

L labo

L calculé

diff

Pos raie

L calc

D lambda

VR

L labo

L calculé

diff

Pos raie

L calc

D lambda

VR

V Sirius

V Terre

Etalonnage

Etalonnage

     Sigma

     Sigma

Dist T - S

millions km

avec corrections

avec corrections

xpos = 597.1 (slider from 0 to 1000, step 0.1)
C2 = 440.48
C3 = 441.51
C4 = 442.73
C5 = 444.23
C6 = 444.77
C7 = 446.17
C8 = 446.65
C9 = 447.6
C10 = 449.46
A2 = 1
A3 = 2
A4 = 3
A5 = 4
A6 = 5
A7 = 6
A8 = 7
A9 = 8
A10 = 9
B2 = 120.2
B3 = 209.3
B4 = 313.5
B5 = 442.2
B6 = 488
B7 = 606.9
B8 = 649.1
B9 = 730.8
B10 = 889
C17 = 440.48
C18 = 441.51
C19 = 442.73
C20 = 444.23
C21 = 444.77
C22 = 446.17
C23 = 446.65
C24 = 447.6
C25 = 449.46
A17 = 1
A18 = 2
A19 = 3
A20 = 4
A21 = 5
A22 = 6
A23 = 7
A24 = 8
A25 = 9
B17 = 118.5
B18 = 206.2
B19 = 309.3
B20 = 436.7
B21 = 482.8
B22 = 601.4
B23 = 642.8
B24 = 723.9
B25 = 882.5
B14: "x = " + xpos
F2 = 122.6
G2 = 440.5012
H2 = 0.0212
I2 = 14.459
F3 = 212.2
G3 = 441.5481
H3 = 0.0381
I3 = 25.8801
F4 = 315.5
G4 = 442.755
H4 = 0.025
I4 = 16.9487
F5 = 444.5
G5 = 444.2622
H5 = 0.0322
I5 = 21.7506
F6 = 490.6
G6 = 444.8008
H6 = 0.0308
I6 = 20.7919
F7 = 609.65
G7 = 446.1918
H7 = 0.0218
I7 = 14.6365
F8 = 651.8
G8 = 446.6842
H8 = 0.0342
I8 = 22.9947
F9 = 733.4
G9 = 447.6376
H9 = 0.0376
I9 = 25.217
F10 = 891.45
G10 = 449.4842
H10 = 0.0242
I10 = 16.1728
I12 = Mean(I2:I10)
F17 = 113.9
G17 = 440.43
H17 = -0.05
I17 = -34.0712
F18 = 203.9
G18 = 441.4882
H18 = -0.0218
I18 = -14.8176
F19 = 305.5
G19 = 442.6828
H19 = -0.0472
I19 = -31.9805
F20 = 433.4
G20 = 444.1867
H20 = -0.0433
I20 = -29.275
F21 = 479.1
G21 = 444.724
H21 = -0.046
I21 = -31.0337
F22 = 597.1
G22 = 446.1114
H22 = -0.0586
I22 = -39.3801
F23 = 639.6
G23 = 446.6111
H23 = -0.0389
I23 = -26.0963
F24 = 720.9
G24 = 447.5671
H24 = -0.0329
I24 = -22.0703
F25 = 878.9
G25 = 449.4248
H25 = -0.0352
I25 = -23.473
I27 = -28.022
I13: I12 / cos(90.0 - 93.0 * °)
I28: I27 / cos(90.0 * ° - 74.0 * °)
C29: (I13 + I28) / 2.0
C30: (I13 - I28) / 2.0
P_1: (B2, C2)
P_2: (B3, C3)
P_3: (B4, C4)
P_4: (B5, C5)
P_5: (B6, C6)
P_6: (B7, C7)
P_7: (B8, C8)
P_8: (B9, C9)
P_9: (B10, C10)
liste1: {P_1, P_2, P_3, P_4, P_5, P_6, P_7, P_8, P_9}
C12 = FitPoly(liste1, 1.0)
D2: $C$12(B2)
E2: D2 - C2
D3: $C$12(B3)
E3: D3 - C3
D4: $C$12(B4)
E4: D4 - C4
D5: $C$12(B5)
E5: D5 - C5
D6: $C$12(B6)
E6: D6 - C6
D7: $C$12(B7)
E7: D7 - C7
D8: $C$12(B8)
E8: D8 - C8
D9: $C$12(B9)
E9: D9 - C9
D10: $C$12(B10)
E10: D10 - C10
E12 = SD(E2:E10)
P_{10}: (B17, C17)
P_{11}: (B18, C18)
P_{12}: (B19, C19)
P_{13}: (B20, C20)
P_{14}: (B21, C21)
P_{15}: (B22, C22)
P_{16}: (B23, C23)
P_{17}: (B24, C24)
P_{18}: (B25, C25)
liste2: {P_{10}, P_{11}, P_{12}, P_{13}, P_{14}, P_{15}, P_{16}, P_{17}, P_{18}}
C27 = FitPoly(liste2, 1.0)
D17: $C$27(B17)
D18: $C$27(B18)
D19: $C$27(B19)
D20: $C$27(B20)
D21: $C$27(B21)
D22: $C$27(B22)
D23: $C$27(B23)
D24: $C$27(B24)
D25: $C$27(B25)
E17: D17 - C17
E18: D18 - C18
E19: D19 - C19
E20: D20 - C20
E21: D21 - C21
E22: D22 - C22
E23: D23 - C23
E24: D24 - C24
E25: D25 - C25
E27 = SD(E17:E25)
C32: C30 * 3600.0 * 24.0 * 365.25 / 2.0 / 3.141592653589793 / 1000000.0
C31: C30 / cos(30.75 * °)
C33: C31 * 3600.0 * 24.0 * 365.25 / 2.0 / 3.141592653589793 / 1000000.0
vcura = Segment((xpos, 280.0), (xpos, 600.0))
vcurb = Segment((xpos, 0.0), (xpos, 260.0))