Lighting Schedule Template: Columns and Step-by-Step Setup
· 9 min read
A lighting schedule template is a table with one row per luminaire type: a type code, location, technical parameters, control, quantity, supplier and lead time. Build it from the final lighting plan, add the parts that are easy to forget (drivers, profiles, control gear), and use the same table for client approval, electrician briefing and ordering. Below are the columns that work in practice, a step-by-step process, a worked example and a review checklist.
What the schedule has to answer
The lighting plan shows where each fixture goes. The schedule says what each fixture is, how it is controlled, how many are needed, who supplies it and when it must be ordered. A good schedule lets three people work from one document:
- The client sees what is proposed, in which room, and at what price.
- The electrician sees the driver type, dimming method and circuit for each code.
- The procurement manager sees quantities, supplier, lead time and the date by which the order must be placed.
If any of these three cannot find their answer in the table, the schedule is incomplete and the question will come back as a phone call during construction.
Columns for a lighting schedule template
Group the columns into five blocks. Not every project needs every column, but removing a column should be a decision, not an omission.
| Block | Column | What to enter | Why it matters |
|---|---|---|---|
| Identification | Type code | L1, L2, L3... the same code as on the plan | Links the drawing, the table and the order |
| Identification | Room or zone | Where the type is used; quantity per room | Budget and delivery by room |
| Identification | Description | Fixture type and mounting: recessed, surface, pendant, wall, track, linear | Shows the intent at a glance |
| Product | Brand and SKU | Exact manufacturer reference, with the product link | Prevents wrong substitutions |
| Product | Finish and dimensions | Colour, size, cutout diameter, recess depth, canopy size | Checked against ceiling build-up and drawings |
| Technical | Light source | Integrated LED or lamp base; power and luminous flux | Compare fixtures by output, not only by power |
| Technical | Colour temperature, CRI | For example 2700 K or 3000 K, and the colour rendering value | Keeps the light consistent across rooms |
| Technical | Beam angle, IP rating | Beam in degrees; protection class for wet zones | Effect on the wall or table; safety in bathrooms |
| Control | Driver and dimming | Driver type and location, dimming method | The most common source of site problems |
| Control | Circuit or scene | Which switch, circuit or scene controls the type | Used by the electrician and the control installer |
| Commercial | Quantity and spares | Installed quantity plus agreed spares | Correct order and correct total |
| Commercial | Unit price, supplier | Price in the supplier currency; supplier name | Budget and payment tracking |
| Commercial | Lead time, order-by date | Delivery time and the latest date to order | Avoids delays at ceiling closing |
| Status | Approval and order status | Proposed, approved, ordered, delivered, accepted | One view of what is still open |
How to build the schedule step by step
- Assign type codes. Go through the final lighting plan and give one code to each distinct fixture. Same product, same finish and same colour temperature means the same code. A different colour temperature or beam angle means a new code, even if the housing is identical.
- Count by room. Record the quantity of each code per room, not only the project total. You need room totals for the budget and for delivery to the correct floor.
- Choose by performance first. Fix luminous flux, colour temperature, colour rendering, beam angle and IP rating, then choose the finish and brand. This order protects the lighting effect when the client asks for a cheaper option.
- Specify the control. For each code, write the driver type, where the driver will sit and how the fixture is dimmed. Confirm that the dimming method of the fixtures matches the control system you plan to use.
- Add accessories as separate rows. Drivers, aluminium profiles, diffusers, end caps, trims, canopies, track connectors and cable are items too. They have their own price and often their own supplier and lead time.
- Add commercial data. Enter supplier, unit price, currency and delivery time. Calculate the order-by date backwards: the date the fixture is needed on site, minus delivery time, minus a buffer you choose.
- Decide on spares. Agree with the client which types get spares. There is no universal number: decorative pieces with long lead times and cut-to-length LED strips are the usual candidates.
- Review and approve. Check the table with the electrician and, if there is one, the lighting designer. Only then send it to the client for approval.
Timing against the construction phases
Recessed housings, profiles and drivers are needed before the ceilings are closed, which is much earlier than pendants and wall lights, which are installed at the end. Sort the schedule by order-by date, not only by room, so that the early items are not ordered together with the late ones.
Worked example
The values below are illustrative only and are not price recommendations.
| Code | Room | Item | Key parameters | Qty | Unit price, EUR | Lead time |
|---|---|---|---|---|---|---|
| L1 | Living room | Recessed downlight, trimless | 3000 K, high CRI, dimmable, 40° beam | 12 | 85 | 3 weeks |
| L2 | Kitchen | Recessed LED profile with strip | 3000 K, IP44, per metre | 6 m | 38 | 2 weeks |
| L3 | Dining area | Pendant, three lamp holders | Brass finish, lamp base E27 | 1 | 640 | 10 weeks |
| L4 | Bathroom | Wall light | IP44, 2700 K | 2 | 120 | 4 weeks |
| A1 | Kitchen | Driver for L2 | 24 V, dimmable, installed in the cabinet | 1 | 45 | 2 weeks |
Notice that the pendant has the longest lead time but is installed last, while the profile and its driver are short-lead items that are needed before the ceiling is closed. A table sorted by order-by date makes this visible immediately.
Review checklist and common mistakes
Before you send the schedule to the client or to procurement, check each of these points:
- Every type code on the plan appears in the table, and every code in the table appears on the plan.
- Quantities per room add up to the project quantity.
- Colour temperature is consistent within each room, and any deliberate difference is written down.
- Every fixture has a driver or a clear statement that the driver is integrated.
- Dimming method is stated and matches the planned control.
- IP rating is confirmed for bathrooms, kitchens and exterior areas.
- Cutout size and recess depth are checked against the ceiling build-up.
- Accessories, cable and profiles have their own rows.
- Every row has a supplier, a price (or a marked “price on request”) and a lead time.
- The order-by date is calculated for each row, and the earliest ones are highlighted.
- It is clear who supplies the lamps for fixtures with a lamp base.
Mistakes that cost time
- Counting fixtures but not drivers. The fixtures arrive and cannot be connected.
- Mixing colour temperatures by accident. Two products with the same name can have different options.
- Keeping separate versions. One table for the client and another for procurement drift apart within a week. Keep one source and export the view you need.
- Ordering before the ceiling height is confirmed. Recess depth and suspension length depend on it.
- Ignoring lead time for decorative items. A pendant that arrives after the handover leaves a bare cable in the room.
How to do it in ArchiBoard
The lighting schedule can live inside the project estimate, so the same rows carry the price, supplier, dates and status. More about the estimates feature and the estimates help chapter.
- Open the project and check that the rooms exist in Rooms; use Add room for any that are missing.
- Go to Estimates and click Add item. Paste the product link and click Auto-fill: the name, photo, price, brand, SKU, dimensions and delivery time are pulled in. Check the fields and click Save item.
- Write the type code at the start of the name (for example “L1 Recessed downlight”) and put colour temperature, IP rating, driver and dimming method in the item description.
- For a type used in several rooms, click Add item above the estimate, turn on In several rooms, tick the rooms and choose Evenly, By quantity or By percent. It stays one item with one purchase and one payment.
- Add drivers, profiles and accessories as separate items in the same way.
- If you already have a schedule in a spreadsheet, use Import instead of retyping it; see the estimate import chapter.
- Switch Group by to By category to see the lighting total, and use By order priority to see what to order first.
- In Vendor & payment, select the supplier and enter the planned delivery date. In Timeline, items in the lighting category are placed in the electrical phase automatically, and the Upcoming purchases block shows what must be ordered first. See also procurement timeline.
- To offer a cheaper alternative, open Item details and click Add analog.
- For client approval, check the lighting items, click Export to PDF, enable Only selected items and click Download PDF. Internal purchase prices and markup are not included in the client PDF.
- When the goods arrive, use Acceptance to check the SKU, colour, dimensions and quantity against the schedule.
FAQ
What is the difference between a lighting plan and a lighting schedule?
The plan is a drawing: it shows the position of each fixture and its type code. The schedule is a table: it describes each code in detail and gives quantities, control, supplier and lead time. You need both, and the codes must match exactly, otherwise the order will not correspond to the drawing.
Should drivers and accessories be separate rows?
Yes, whenever they are bought separately. Drivers, profiles, trims and connectors have their own price, supplier and lead time, and they are the parts most often forgotten. If the driver is integrated into the fixture, write that in the description so nobody orders a second one.
How many spare fixtures should I add?
There is no universal number. Decide by type: spares make sense for items that are hard to reorder, such as decorative pieces with long lead times, and for LED strips that are cut to length. Agree on spares with the client and show them as a separate quantity so the total stays transparent.
Who should approve the schedule before ordering?
At minimum the client approves the choice and the budget, and the electrician confirms drivers, dimming and circuits. If a lighting designer works on the project, they check the technical parameters first. Only after these approvals should the items move to ordered status.
When should I order lighting?
Work backwards from the date each item is needed on site. Subtract the delivery time and a buffer you choose. Items hidden in the ceiling, such as recessed housings, profiles and drivers, are needed before the ceiling is closed, so they are ordered earlier than pendants and wall lights.