When having the SPD already digitalized, using the Bulb's analyzer tool is very easy:
Open the BA tool and select the right model sheet (1,5 or 10nm waveband).
1-Opening a new sheet.
A safe thumb of rule is to copy it on a new calc spreadsheet, so if you do any mistake, you dont need to download it again. Let the models as backput of the sheet.
In order to do it, go to the upper right corner and click on "Files", "New", "calc sheet". By default it opens sheet with three pages.
If you already have it and you just need to add a new page, go to the bottom, where you select between the different pages, rightclick and select "Insert sheet".
2-Copying the BA's model.
Click on the right upper corner of the model sheet (the empty square linking columns and raws). All the sheet change of color (you have selected all it). Move the pointer over the sheet, rightclick (if you leftclick, you undo the selection) and select "copy".
Go to the just opened sheet (step 1), rightclick and select "paste"
Now you have a copy of the sheet ready to be used.
3-Copying a digitalized SPD.
Go to the SPD's library and copy the selected SPD (explained on 6c of last post). Go to your new sheet, click on the first yellow column below hte green header "SPD", then rightclick and select "special paste". Like on 6c, select only paste numbers.
After this step, now you have avalaible the spectral analysis. Its shown on the upper right:
4-Analyzing a given model.
You may analyze up to 12 different lamps using emitting same SPD on each sheet. It may be different wattages (mostly) or for example, different combinations of bulb/ballast.
For analyzing a given lamp, you need to fill in its data:
As noted on the 2nd post, you must fill in at least wattage and emission on Klm (1000lm).
In this case, i dont have price info, so i wont get any data related to that:
I hope you will find the BA tool useful.

knna