Is Excel enough for your lighting audits?
Excel is cheap, familiar and flexible. It is also where fixture counts, savings math, rebate assumptions and proposal versions start to drift. Here is how to tell when Excel is enough and when a connected workflow is worth it.
The short answer
Choose Retrolux if
- You audit regularly and need photos, floor plans and fixture-level data in one place.
- You want savings, rebates and proposals generated from the same data.
- You need multiple solutions, team roles and version control.
- You want to export to Excel without losing the audit trail.
Choose Excel if
- You run one-off counts and simple wattage math.
- You have a workbook your team already knows and trusts.
- You do not need photos, product catalogs or proposal generation.
- You want zero software cost and full control of the format.
What Excel does well.
- They are cheap and already on most desks.
- They are infinitely flexible when the project is unusual.
- Most estimators already know how to build and audit a formula.
- A workbook is easy to share, print and hand to a colleague.
Where Excel breaks down.
- Fixture photos live in a folder, not with the fixture line.
- The audit, savings calculation and proposal are separate files.
- A copied workbook becomes the new truth without anyone noticing.
- Product prices and rebate rules are re-entered by hand.
- Two people cannot safely edit the same project at once.
- There is no audit trail for a change the customer questions later.
Excel vs Retrolux.
The comparison is not about whether Excel can hold a number. It is about how much manual work it takes to keep the audit, the estimate and the proposal telling the same story.
| Capability | Retrolux | Excel |
|---|---|---|
| Capture | ||
| Field capture | Mobile audit on a tablet, online or offline | Manual entry at a desk, or a form you build |
| Photos | Tied to the fixture and space | A separate folder or a manual link |
| Floor plans | Fixture pins on a floor plan | Not built in |
| Fixture library | Reusable fixtures and audit attributes | Lists you build and maintain |
| Design and estimate | ||
| Product catalog | Manufacturer catalogs, pricing and ordering | Manual model numbers and prices |
| Savings math | Calculated from the audit data | Formulas you build and check |
| Rebates | Per-fixture estimates in the project | Manual notes and formulas |
| Multiple solutions | Unlimited solutions and ECMs | Duplicate tabs or workbooks |
| Proposal and team | ||
| Proposals | Branded PDFs from 35+ templates | Manual document assembly |
| Version control | One project, one source of truth | Files and versions can drift |
| Team access | Roles and permissions | A shared file with no audit trail |
| Export | CSV/Excel export with photos and attachments | Native format |
Excel capabilities shown are general; a workbook can be extended with macros, scripts and add-ons. Retrolux details are from our product documentation, checked November 2026.
The real cost of Excel.
The license is only one line. The bigger cost is the time spent moving data between the audit, the estimate and the proposal, then finding the version everyone trusts.
Illustrative assumptions, not a customer benchmark. Replace the inputs with your own numbers.
- Audit capture
- 4 hours
- Re-keying and cleanup
- 2 hours
- Proposal assembly
- 3 hours
- Rework from version drift
- 1 hour
Walk the site, count fixtures, record the schedule and take photos.
Move the notes into the workbook and reconcile the counts.
Rebuild the customer document from the workbook.
Find the current file and fix a formula, a stale price or a count.
Total per project
10 hours
Loaded labor rate
$75/hour
Projects per year
20
Illustrative annual cost
$15,000
Migrating from Excel.
You do not have to abandon the workbook on day one. Start with one project and keep Excel available until the new workflow is proven.
Export the workbook and keep a copy.
Save the current file, any linked files, photos and the last proposal you sent. Keep the originals in one folder before you change anything.
Map the columns to Retrolux.
We review the workbook, map the fields your team uses and configure audit fields, catalogs and proposal templates. Bring the product and price list behind the workbook.
Run one project in both tools.
Audit one building in Retrolux while Excel stays available. Compare the estimate and the proposal with the last project you delivered, then move the rest of the team.
Free template
A lighting audit template you can use today.
The CSV includes the columns we see most often in a lighting audit: site, area, fixture type, quantity, existing watts, hours, proposed replacement, proposed watts, material cost, labor, rebate, notes and a photo reference. Open it in Excel, Google Sheets or Numbers.
Excel questions.
The questions teams ask before they replace a workbook with a connected workflow.
Ask a questionIs Retrolux still operating?
Is Excel good for lighting audits?
What should a lighting audit Excel template include?
Can Retrolux import my Excel workbook?
How much does Excel cost compared with software?
When should a contractor switch from Excel?
Compare the software too.
If you have outgrown Excel, these comparisons cover the tools buyers shortlist next.
SnapCount alternative
Choose SnapCount for procurement and job tracking; choose Retrolux for a focused audit-to-proposal workflow with product catalogs and proposals.
Compare Retrolux and SnapCount
LumaQuote alternative
Choose LumaQuote for a published price and a self-serve start; choose Retrolux for deeper audits, product catalogs and enterprise workflows.
Compare Retrolux and LumaQuoteLighting Assessor alternative
Choose Lighting Assessor for a low-cost app with CRM and margin tools; choose Retrolux for deeper audits, catalogs and proposals.
Compare Retrolux and Lighting AssessorBring one Excel project to a demo.
We will show you how the same audit, product data and proposal look in Retrolux, and where Excel still fits.
