program to resolve merged lines

[Robin Leadbeater]

Does anyone know a (windows) program to resolve merged lines into separate components (Gaussians for example) ? I had a program but lost it in a computer crash and I cannot remember the name

Thanks
Robin

[Francois Teyssier]

Robin,
I use the solver of an excel sheet - it works well
Here's an example with [OIII] and He I lines of CI Cyg

cicyg.PNG (52.04 KiB) Viewed 7679 times

A can send you the sheet if you want

There's also FITYK

François

[Robin Leadbeater]

Thanks François,

I have not used FITYK before but it looks like it should work. That is a nice looking spreadsheet. Yes I would like to try it. Is it your own design?

Cheers
Robin

[Jacques Montier]

Hello François and all,

I would also be interested by your Excel sheet about resolving merged lines.

thanks very much in advance,

Cheers,

[Francois Teyssier]

OK,
So here's the link to the worksheet
http://www.astronomie-amateur.fr/Docume ... Cygni.xlsm

The spectra are in sheet "Base"
A new spectrum can be added by clicking button "Importation"
The new spectrum must :
be in .dat format
respect ISIS standart for the name
be rescaled at 1A/px
(this version is for low resolution spectra)
You add the V mag line 3

In the sheet "index" , you choose your spectrum

Spectre.PNG (5.79 KiB) Viewed 7651 times

Note : there's sometimes a bug (if the the first wavelenght changes from one spectrum to another)
The bug is fixed when you change the line (see above)

You tune the interstellar extinction. Here : E(B-V) = 0.4

Then you choose the line to analyse

raie.PNG (5.7 KiB) Viewed 7651 times

The line list is in sheet "Data" : you can change the list

You adjust the cursors for continuum (red line) and integration zone (dashed lines)

The result : EW, Absolute flux appears in

Rapport.PNG (5.46 KiB) Viewed 7651 times

By clicking on "Rapport", the sheets "Rapport G1" = EW and "RapportG2" = Absolute flux are updated
And the graphs are also updated (Graphes and Graphes2) - On these two sheets the button "Export Graphs" generate the .png files for each graph (names in column AA)

Back to Index
For gaussian fitting
Choose [OIII] 5007 line, adjust continuum, integration zone (the two lines 5007 and 5016 in the integration zone)
In cells B21:B23, D21:D23 and E21:E23, give approximative values
For instance

OIII_params_approx.PNG (5.86 KiB) Viewed 7651 times

The result appears in the left graph :

OIII_aprox.PNG (8.3 KiB) Viewed 7651 times

Then, use the Solver (In the "Données" windows of EXCEL2010, don't know the name of the window in Englisg Version

DonneesXLS.PNG (36.77 KiB) Viewed 7651 times

The result :

OIII.PNG (8.77 KiB) Viewed 7651 times

and the values :

OIII_params.PNG (6.05 KiB) Viewed 7651 times

With two lines, they are to be copied manually in Sheets Rapport (I've to build a macro ...)

You can also fit other lines
For instance, H alpha lines in symbiotic are the sum of two gaussian (a broad one for the piedestal and anarrower for he main component)

Ha.PNG (8.84 KiB) Viewed 7651 times

and

Ha_Param.PNG (6.07 KiB) Viewed 7651 times

Voilà, j'ai d'autres modèles, adaptés à chaque type d'objet (Miras, NP, Novae, SN ...)


Bien sûr, ce sont des fichiers de travail. Celui de CICygni a deux ans maintenant. Je l'ai commencé uniquement avec des formules xls avant de rajouter des macro, des nouvelles fonctions ..., donc ça devient un peu usine à gaz. il faudrait que je le reprenne complètement.

François

[Jacques Montier]

Ok, i got it !
Thank you very much François !

Cheers,

[Martin Dubs]

Francois,

merci pour ton sheet EXCEL. Chaque jour je trouve quelque chose de nouveau. C'est comme un calendrier de noel, avec des fenêtres pour trouver un truc nouveau. Le SOLVER marche très bien, je l'ai utilisé avant souvent pour calculer des problèmes divers. Un jour je vais essayer de integrer ma formule du flux peut-être. Une reference externe ('C:\Users\FM\AppData\Local\Temp\[EBV_v5.xlsm]MILES_Reg') j'ai remplacé par la copie locale pour eviter un petit problème.

Une bonne année nouvelle pour tous,

Martin

[Olivier GARDE]

François,

Super ton tableau excel, un outil précieux que je vais essayer de maitriser au mieux....

Bonne année 2014 à tous !!!!

Olivier GARDE