spectro-aras.com

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

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
A can send you the sheet if you want

There's also FITYK

François

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

Hello François and all,

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

thanks very much in advance,

Cheers,

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 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 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 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 The result appears in the left graph : Then, use the Solver (In the "Données" windows of EXCEL2010, don't know the name of the window in Englisg Version The result : and the values : 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) and
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

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

Cheers,

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

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