DEV Community

RickZhang
RickZhang

Posted on AI-assisted

Where Part 3 Submittals Hide in MEP Specs and 4 Procore Excel Import Traps

The electrical spec for a public irrigation project calls for an installed-motor test form for each motor. The same paragraph adds two measurement times for motors rated 50 hp or larger. If your submittal log says “motor test form, 50 hp and above,” it drops the paperwork for every smaller motor covered by that requirement. The original clause is in Part 3, on printed page 26 05 00 - 24. Hawaiʻi DOAM10 electrical specification, Section 26 05 00 §3.04.E

Here’s how I would turn a single specification section into a reviewable submittal log, then format a draft for Procore Imports. I built SubmittalPrep, the tool used for the workbook example at the end.

Read past the Part 1 submittals heading

Scan the technical section from Part 1 through Part 3. Search for reporting and handover language such as submit, record, notify, test report, certificate, and warranty. For each hit, write down what the project team owes, who supplies it, when it is due, and which equipment or condition it applies to. Record the section, clause, physical PDF page, and printed page or drawing number so a reviewer can find the source again.

Public bid specification Clause to check What goes in the review log
Hawaiʻi DOAM10, Division 26 26 05 00 §3.04.C and §3.04.E, printed p. 24 Conductor results go on Form 26 05 00-A or in a similar format. The clause specifies a 1,000 V megohmmeter for 600 VAC-rated insulation and all motors, and rejects insulation resistance below 10 MΩ. Installed-motor Form B applies to each motor. Measure before connection, with additional measurements at delivery and after connection for motors rated 50 hp and up.
Winnipeg Conway Lift Station, Division 22 22 05 04 §3.3.4–.6, printed p. 3 Notify the City’s Representative at least 72 hours before concrete water-retaining structure testing. Submit the procedure and leak detection method in writing. The standard test procedure discussed in that clause runs 48 hours. Keep the notice and test duration in separate fields.
Kirkland City Hall Annex, Division 23 23 81 50 §1.04.A.1–.3, printed p. 2 Record the manufacturer’s 10-year parts and compressor warranty, starting at installation, with labor excluded. The warranty is under its own Part 1 heading, outside the submittals list.

Hawaiʻi electrical specification · Winnipeg technical specifications · Kirkland VRF bid specification

Read the project’s Section 01 33 00 alongside the technical section when the contract provides it. Use the general section to establish routing, review time, and delivery format. Keep individual test forms, certificates, and warranties tied to the technical clause that calls for them. Where the project’s own terms leave a judgment call, leave it visible for the reviewer.

Check reading order and which condition goes with which task

On sheet M0.04 in Miami-Dade’s mechanical bid set, the warranty clause sits beside other mechanical requirements. In a local text extraction check, the plain text stream put an instruction about an active pipe and duct immediately before the warranty heading. Its next numbered heading after the factory-warranty text was §2.4 on construction record documents. The layout-preserving extract exposes the columns. Open M0.04 beside the text output and trace each clause down its own column before relying on a pasted extract. Miami-Dade solicitation, Volume 2, sheet M0.04

The Hawaiʻi example has a different failure mode. An earlier extraction draft found Form B and the phrase about 50 hp, then attached the threshold to who owed the form. Checking the original paragraph exposed the mistake. In the review log, split the requirement into two rows or two fields. Put Form B after installation on the row for every motor. Put repeat at delivery and after connection on the row for motors of 50 hp or more. Preserve the original clause beside both so the PM can make the final call. Hawaiʻi DOAM10 electrical specification, §3.04.E

Four Procore Excel import traps

  1. Excel changes the spec section ID. Preserve the existing project value, including spaces and any leading zero, such as 01 33 00. Check the saved file after pasting or exporting. Use Procore’s current template and its documented number-format guidance when your spreadsheet strips the zero. Procore template guidance
  2. The manager field has a name or an email the project cannot resolve. Fill the required Submittal Manager with the exact Project Directory email for a person with the appropriate permissions. Fill the required Submittal Number using the project’s numbering convention and keep the revision out of that column. Procore required fields
  3. Excel rewrites dates. Where the template calls for dates, keep the cells formatted as Text and use two-digit month and day and a four-digit year. For example, enter 02/07/2027 in a date field. Match any status or type you include to the options in the destination project. Procore date, status, and type formatting
  4. The review workbook and the import file get mixed together. Keep clause references, source quotes, and review notes in the checklist. Use the 22-column draft to prepare a standalone import workbook with the official columns in their original order and the required project values filled in. If the import is for an existing package, its identifying values must match. Leave package columns A–D empty when importing without a package. Procore import and package instructions

Open a worked HVAC example

The 11-page Section 23 34 23 demo shows the same workflow in a smaller file. On physical PDF page 9, clause 3.04.A.3 captures field airflow test records. The review tab shows the clause and source, including printed page 23 34 23 - 8. The second tab shows a draft with the 22 Procore columns. The workbook leaves the project-specific fields for the importing team to complete. Download the free two-sheet HVAC sample

For a manual start, the template repository includes a blank annotated workbook and the completed HVAC example. Get the blank 22-column template on GitHub

To follow along in the browser, open the tool and choose Try sample HVAC spec. Start by finding the field-test row, opening its source, and checking that both page references take you to the same requirement. Open the spec-to-submittal-log tool

Disclosure: Written with AI assistance using the cited public specifications and extraction checks. I built SubmittalPrep.

Top comments (0)