Retrolux

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.

Excel vs Retrolux comparison
CapabilityRetroluxExcel
Capture
Field captureMobile audit on a tablet, online or offlineManual entry at a desk, or a form you build
PhotosTied to the fixture and spaceA separate folder or a manual link
Floor plansFixture pins on a floor planNot built in
Fixture libraryReusable fixtures and audit attributesLists you build and maintain
Design and estimate
Product catalogManufacturer catalogs, pricing and orderingManual model numbers and prices
Savings mathCalculated from the audit dataFormulas you build and check
RebatesPer-fixture estimates in the projectManual notes and formulas
Multiple solutionsUnlimited solutions and ECMsDuplicate tabs or workbooks
Proposal and team
ProposalsBranded PDFs from 35+ templatesManual document assembly
Version controlOne project, one source of truthFiles and versions can drift
Team accessRoles and permissionsA shared file with no audit trail
ExportCSV/Excel export with photos and attachmentsNative 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

Walk the site, count fixtures, record the schedule and take photos.

4 hours
Re-keying and cleanup

Move the notes into the workbook and reconcile the counts.

2 hours
Proposal assembly

Rebuild the customer document from the workbook.

3 hours
Rework from version drift

Find the current file and fix a formula, a stale price or a count.

1 hour

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.

Download the CSV

Excel questions.

The questions teams ask before they replace a workbook with a connected workflow.

Ask a question
Is Retrolux still operating?
Yes. Retrolux is operating and is not shutting down. Customer accounts and data remain available after November 30, 2026, with nothing to export or migrate. Read the statement
Is Excel good for lighting audits?
Excel is a good fit for a one-off count, a simple wattage comparison or a workbook your team already knows. It becomes harder to manage when you need fixture photos, floor-plan locations, product pricing, rebate rules, multiple solutions and a customer-ready proposal from the same data.
What should a lighting audit Excel template include?
Include the site, area, fixture type, quantity, existing wattage, operating hours, proposed replacement, proposed wattage, material cost, labor, rebate estimate, notes and a photo reference. Add a version date and an owner so the team knows which file is current.
Can Retrolux import my Excel workbook?
Retrolux supports bulk changes and data imports, and exports project information to CSV or Excel. The exact import format depends on the fields and catalog setup on your account. Send us a sample workbook and we will map the columns with you.
How much does Excel cost compared with software?
The license is only one cost. Count the hours spent re-keying data, rebuilding formulas, assembling proposals and correcting version drift. The worked example on this page shows how those hours add up. Replace the assumptions with your own team's numbers.
When should a contractor switch from Excel?
Switch when the workbook is no longer the source of truth, when more than one person needs to edit the same project, or when the proposal takes longer to assemble than the audit takes to complete. A good test is to run one real project in both tools and compare the total time.

Bring 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.