MILES Search Spreadsheet

[Patrick]

Hello,
My reading (sometimes a dangerous pass-time?) has caused me to ask some questions regarding the E(B-V) values in your fine MILES Search spreadsheet. I understand the difference between using reddened/dereddened data when processing spectra.
I quote the following:

E(B-V) is related to interstellar reddening and is customarily quantified as color excess by:
E(B-V) (color excess) = (B-V) (observed color index) - (B-V)0 (the intrinsic color index)
A color index is the difference between the magnitude of a star measured at one standard wavelength and the magnitude at another, albeit longer, standard wavelength: this is a quantitative measure of a star’s color.
The intrinsic color index may be predicted from its spectral type.

Q1. Are you able to explain what calculation produced the E(B-V) data in your spreadsheet?
Q2. Where is the data used in such calculations available?
Q3. Are you able to provide any comments about how to determine the intrinsic color index?
I hope this is clear and not too far from the general interests of Astroart?
Regards,
Patrick.

[merlin66]

Patrick,
Which spreadsheet are you discussing?
I use the Miles (and Pickles) database in BASS Project for my spectrography.
Have you looked at:
http://research.iac.es/proyecto/miles/p ... s-seds.php

[Patrick]

Ken,
No I have not and thanks for the reference.
I apologize for not being specific re my question.
I refer to that by Paolo Berardi http://www.spectro-aras.com/forum/viewt ... 1&start=10
Regards,
Patrick

[Patrick]

And I apologize AGAIN this time for not doing my homework.
I have mixed up my Paolo's and this question should not have been sent here.
Regards,
Patrick.