Choose the right copper inventory lane
Start by deciding whether a line is an identifiable copper cable record or an unclassified recovery-only grouping. A labeled reel with a readable jacket legend and one continuous remaining length belongs in the first lane. Short pieces, missing labels, or a mixture of unlike conductors belong in a separate line with uncertainty stated plainly.
Do not convert a scale reading into copper content. A loaded reel can include wood, steel, insulation, jacket material and packaging. Keep footage, cable weight and gross loaded-reel weight as different fields, even when the same inventory reference is used.
- Transcribe the manufacturer name or part number and the full readable jacket legend.
- Record AWG or kcmil, conductor count, insulation designation and one reel identifier.
- State whether footage is measured, documented or unknown; do not infer it from weight.
Build a reel record that can be checked
Photograph a readable tag, a stretch of jacket printing, the complete reel and accessible cable ends. Use the same reference in the spreadsheet and file names, such as CU-ALB-01-tag and CU-ALB-01-jacket. If an image supports only condition, say so; it does not establish conductor-only weight or remaining footage.
For a partial reel, preserve the original tag quantity as historical documentation and enter the current balance separately. When no current measurement exists, write unknown or estimated with the method rather than repeating the original shipped length as the quantity offered.
- Reel ID and photo filenames that share the same prefix.
- Current continuous footage and its basis.
- Gross loaded-reel, cable-only, net, or unknown weight basis.
- Storage condition and any mixed pieces kept outside the identified line.
Keep mixed pieces out of the labeled-reel claim
A mixed bin may contain copper, other metals, cut ends and insulation in quantities that cannot be traced to the labeled reel. Give it its own reference, describe what is visible, and keep any scale figure tied to that reference. Do not let a representative reel photo stand in for a mixture stored beside it.
The specific error to avoid is calling a 900 lb loaded wooden reel 900 lb of copper. Correct the record by calling it gross loaded-reel weight, retaining the cable identity record, and putting separate mixed pieces on their own line. Unknown conductor-only weight remains unknown until a documented basis exists.
- One line for identified reels and another for mixed or short pieces.
- A stated reason when metal, footage or condition is unconfirmed.
- No assumed conductor weight based on a reel, hub or package total.
Albany context for a heavy-reel record
The Port of Albany is a 430-acre inland port spanning Albany, Bethlehem, Rensselaer and East Greenbush, with bulk, breakbulk, heavy-lift and other cargo activity.
That city context does not identify a seller, a cable lot or a buying commitment. It only makes a durable reel reference, documented dimensions, weight basis and seller-reported access limits especially useful when a lot needs a practical handling discussion.
- For a large reel, note diameter, flange width and whether weight includes the reel.
- State the storage location and who can authorize release without assuming a collection method.
Illustrative copper inventory record
This fictional record shows the level of separation needed before a buyer can review an identified reel alongside a mixed group. It is a format example, not an actual Albany transaction or a statement that a particular lot will be purchased.
- Inventory reference: CU-ALB-01.
- Cable record: insulated copper conductor; jacket legend photographed.
- Weight basis: 900 lb gross loaded reel; conductor weight unknown.
- Continuous footage: unknown; not represented by the scale figure.
- Separate pieces: short mixed cutoffs listed on a different line.
