While I was defining my custom LED kit for the STTNG, I found that the light schema in the manual is partially incorrect (duplicate numbers and missing lamps) and also the kits of suppliers are incomplete. In the restoration process I stripped my play-field, mapped all lights and created an excel sheet where I can compile my own lamp selection and automatically generate a part-list to ease the ordering. I tried to align the numbering with William's original numbering and clarify the names of the lamps and their color.
Excel sheet (customizable)
PDF version (read only)
Usage:
1) change your selection in column "G" on the first tab (make sure to use unique names for the same item)
2) go to the second tab (PartList), right click on the pivot table and select "refresh data"
3) in column "C" you'll find the correct number of the parts to order (do not use column "B" of the pivot table).
Note: I chose pinball.center's noflix plus LEDs for myself but I'm not affiliated with them nor do I want to advertise them.
In the attached image you'll see a screenshot of the sheet.