The Student Room Group
Uni students - Complete our survey >>
Uni students - Complete our survey >>
Uni students - Complete our survey >>

Brackett Series - Excel sheet

I want to produce a simple Excel sheet to calculate the wavelengths of H atom transitions and calculate, in nm, the first 4 lines of the Brackett series.

Would anyone know what is wrong with the Excel sheet I have attached?
Brackett.xlsx29.3KB
Original post by little pixie
I want to produce a simple Excel sheet to calculate the wavelengths of H atom transitions and calculate, in nm, the first 4 lines of the Brackett series.

Would anyone know what is wrong with the Excel sheet I have attached?


For each value of r', there is a corresponding series of r and hence a wavelength.

i.e.

r' = 1 : r = 1, 2, 3, 4.....n
r' = 2 : r = 1, 2, 3, 4.....n
r' = 3 : r = 1, 2, 3, 4.....n
r' = 4 : r = 1, 2, 3, 4.....n
r' = m : r = 1, 2, 3, 4....n
Original post by little pixie
I want to produce a simple Excel sheet to calculate the wavelengths of H atom transitions and calculate, in nm, the first 4 lines of the Brackett series.

Would anyone know what is wrong with the Excel sheet I have attached?


In the formulas for wavelength you have written n for both n and no
You must write a cell reference, not a variable name, for n
So in formula in G6 you should have E6 not n
(edited 10 years ago)

Quick Reply

Related discussions

Latest

Trending

Trending

Articles for you