Transcribe the distribution construction
Create one row per reel before trying to group anything. Copy the manufacturer and part number when readable, conductor metal, AWG or kcmil, marked voltage, and neutral, shield, or configuration details. “Underground project cable” is a location label, not a complete product description.
Palm Beach County Water Utilities identifies its Southern Region Water Reclamation Facility as being in Boynton Beach. That is city context for a utility-related inventory scenario only; it does not identify cable at that facility, a seller, or material available for purchase.
- Transcribe tag and jacket markings without shortening the designation.
- Record conductor metal, size, voltage, and neutral or shield configuration separately.
- Write unknown when the tag or accessible evidence does not supply a field.
Keep the quantity reel by reel
Record the reel ID, remaining continuous footage, and the basis for that figure. If two reels are grouped, show why their construction matches and retain the footage for each reel. A grand total can conceal whether the material is one usable length or several unrelated lengths.
Weight and dimensions can be useful handling facts, but state whether a weight is gross or net and whether it is measured, documented, or estimated. Do not treat a loaded reel weight as a cable-construction record.
- Give each reel an ID and continuous-footage field.
- Keep the number of reels separate from footage per reel.
- Label every weight and dimension with its available basis.
Document ends, storage, and condition
Match a tag close-up, jacket-printing photo, overall reel view, and accessible-end photo to the same reel ID. Record known storage history, end protection, visible jacket or flange damage, and whether the cable is uninstalled or previously removed. If an end cannot be accessed, say so rather than describing an unseen condition.
Condition photos document visible facts; they do not establish electrical performance. Keep different histories separate instead of using the cleanest reel as evidence for the rest of a mixed group.
- Note missing end protection, moisture exposure, and visible damage when known.
- Keep uninstalled and previously removed cable in separate rows.
- Use photo filenames that include the reel ID.
Record release and site facts without assumptions
For each storage location, identify the owner or authorized release contact, the actual storage location, access limits, and the loading equipment that is present. A person who can point out a reel is not necessarily the person who can authorize its release.
State practical limits such as gate controls, escorts, site requirements, or a requested release window. These are facts for a lot-specific discussion; they do not establish transport, purchase, or acceptance terms.
- Name the release authority and their relationship to the listed stock.
- Describe access limits and available equipment as observed facts.
- Keep location-specific restrictions attached to the relevant reel rows.
Correct a mixed distribution listing
ILLUSTRATIVE ONLY — not a purchased lot. A fictional record for UD-BB-02 lists a distribution designation copied from a tag, an unknown neutral configuration, 580 ft documented on one warehouse reel, and a gross-weight note that includes packaging. It demonstrates how unknowns remain visible.
The specific mistake to avoid is one row called “underground project cable” that combines different voltage, neutral, or shield configurations under one total. Split the record by matching construction and reel, then preserve the quantity basis for each row.
- Illustrative line: UD-BB-02.
- Neutral configuration: unknown, not inferred from another reel.
- Footage: 580 ft documented on one fictional warehouse reel.
