Free Electrical Project Management Template

Most contractor project management templates are a picture of a schedule. You type dates into one column, the sheet draws bars in another, and nothing in the file knows whether the bars are true. This one is built the other way round: the rows are the schedule, and everything on the page is computed from them. Give a task a planned start and a planned finish and it tells you the duration in calendar days. Give it an actual finish and it tells you the slip, signed — positive for late, negative for early. Across the whole job it rolls up the earliest planned start, the latest planned finish and the project duration, so you can see in one line whether the sum of your phases still fits inside the contract.

The day counting is the part that quietly goes wrong everywhere else. A task planned from the 2nd to the 6th is five days of work, not four — both endpoints are working days on your schedule, so the span is inclusive. A slip, on the other hand, is a difference between two dates and is exclusive: finish on the planned date and you have slipped nothing; finish the next day and you have slipped one. Mixing those two conventions in the same sheet is how a five-day phase quietly becomes four and a project comes in a week short on paper. This template uses inclusive counting for every span and exclusive counting for every difference, and says which is which.

Overdue is graded against a status date you type in, not against today's clock. That sounds like a detail until you print the schedule, email the PDF to an owner and open it again three weeks later — a sheet that reads the clock will have quietly re-graded itself, and the copy in the owner's inbox no longer matches the copy in your file. A status date makes the document a statement about a moment: as of this date, these tasks were past their planned finish by this many days. That is a document you can attach to a delay notice.

The hold points are the difference between this and a to-do list. A hold point is a gate that blocks a phase from closing out, and while one is open the phase does not read complete no matter how many tasks are ticked — and it names the gate rather than reporting "1 item outstanding". Four of the gates come from the 2021 IBC administrative chapter, which reaches every trade here because Section 105.1 makes the permit cover electrical, gas, mechanical and plumbing systems as well as the building: the permit itself (105.1), approval before the work goes beyond the point of each successive inspection (110.6 — the concealment gate), the final inspection after all permitted work is complete (110.3.12), and the certificate of occupancy before the space is used (111.1). The mechanical rough-in gate is 2021 IMC 112.2.2. The AHJ electrical inspection — marked AHJ rather than code on purpose, because the NEC publishes no inspection schedule at all.

Some gates deliberately carry no citation. Equipment delivery, submittal return and owner sign-off are contract terms, not code, and they are labelled Contract on the page and in every export rather than dressed up with a section number. Electrical inspection sequencing is labelled AHJ for a specific reason: the NEC contains no inspection schedule at all — its administrative provisions live in Article 80, which is a model law in an informative annex and only has force where a jurisdiction adopts it. Plumbing subsection numbers are not printed either, because the IPC renumbered its administrative chapter between editions, so the sheet cites the IBC section that governs plumbing work instead of an IPC subsection that may not exist in your adopted edition. Editions, local amendments and the authority having jurisdiction always govern.

The change order and RFI log is where the money arithmetic matters. Cost impact is signed, because a credit is a real thing and clamping it to zero would flatter every job. The totals are accumulated in whole cents and divided once, so a list like $1,029.37, −$319.10 and $4,289.73 sums to exactly $5,000.00 rather than the $4,999.999999999999 that plain floating-point addition produces — which is the difference between a revised contract value that ties out and one an owner's accountant queries. Only approved items move the contract value and the finish date. Open items are totalled separately as exposure, with a second finish date showing where you would land if every one of them were approved, because that is the number to put in front of an owner before the argument, not after it.

An electrical schedule waits on the utility and the inspector, neither of whom reads your Gantt chart. Track the gate, the date it cleared, and what it cost you in days when it did not.