Values / Excel / Planetary

Favorite values for Excel formulas I like to use:

Distance (ly)

Distance (m)

Flux (W/m^2)

Luminosity (W)

Conversion (Ls)

Temperature (K)

Star Radius (Rs)

Lifetime

Brightness Drop %

Normal brightness

Doppler shift (nm)

Rest wavelength

(Rj)

Orbital Period (au)

Radial Velocity (m/s)

Energy (Fs) (W/m2)

Albedo

Effective Temperature (K)

% Energy Absorbed

% Energy Transmitted

Greenhouse Effect

Surface Temperature


Type of star / Color (mn)

Extreme UV: 10 - 100 nm

UVC: 100 - 280 nm

UVB: 280 - 315 nm

UVA: 315 - 400 nm

Violet: 400 - 450 nm

Blue: 450 - 475 nm

Cyan: 475 - 495 nm

Green: 495 - 570 nm

Yellow: 570 - 590 nm

Orange: 590 - 620 nm

Red: 620 - 750 nm

Near IR: 750 - 1,400 nm

Shortwave IR: 1,400 - 3,000 nm

Midwave IR: 3,000 - 8,000 nm

Longwave IR: 8,000 - 15,000 nm

Far IR: 15,000 - 100,000 nm

Microwave: >100,000 nm


My Excel formulas:

3.26/A2

B2*i2

D2*4*PI()*(C2)^2

E2/H2

2,897,768.50

(f2)^(1/3.5)

f2^0.5/(g2/5800)^2

10^10*(A8)^(-2.5)

(d8/100)^(0.5)*(b8)*109

(Re)*H3

(C15)/(365)/(1)

(D15^2*A8)^(1/3)

0.0352*(Radial Velocity^2*au*Ms)^(0.5)

11.177*(f15^2*e15*a8)^(0.5)

(F8)/(G8)*(H3)

(4/3*PI()*(b22)^3)

A22/C20

VE+D/2

(4/3)*Pi()*(Radius of sphere)^3

4*Pi()*radius of sphere^2

Surface Area of Sphere/Volume of Sphere

a26*g20

b26*g22

b28/(4*pi()*(a28)^2)

(e28*(1-f28)/(4*5.67e-8))^(0.25)

a20*g24

b20*g25

G28+f35