Python Script Flags Stale Wattage Totals and Unverified Heights in Lighting Schedules
A lighting schedule may look correct in the editor while the exported CSV contains an outdated wattage total. The article illustrates this with two rows for the same 10 W open-frame bollard, where one row's stored total of 40 W no longer matches its revised quantity. A Python script compares each row's quantity and unit power against the catalogue and flags mismatched totals as well as heights not listed for the selected model. In the sample, the script reports one stale total and one unconfirmed height, yielding a nominal load of 90 W that still requires verification. The author recommends keying lookups by model and version for multi-model exports and keeping recessed fixture body, cutout and sleeve data as separate sourced fields. The example data comes from a fixture schedule guide published by Veilumen, and the technical adaptation was AI-generated.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in