AllFiber → Field guides → Splice sheet generator

Splice sheet generator: start from the cable build

A splice sheet generator takes a cable's build (fiber count, fibers per tube, color standard) and writes one row per fiber with the tube color and fiber color already filled in, leaving blanks for tray, splice loss and notes. Any spreadsheet can do it. What makes the output trustworthy is the input: generate from the manufacturer's spec sheet for the exact part number, not from the fiber count alone, because the same count can be built more than one way. Fiber Optic Color Code Lookup from AllFiber doesn't write the sheet. It's the offline check for any row that doesn't match the strand in your hand.

Generators got complicated. The sheet didn't.

Search for a splice sheet generator and the options run from free spreadsheet templates to network design software built for the planner's desk. Most of that never goes down the manhole.

Strip it back. A splice sheet only has to do three things well:

  1. Say which fiber is which before anyone cuts.
  2. Record what was actually done, splice by splice.
  3. Let the next tech, a year from now, open the closure and trust it.

Everything a generator adds beyond those three is convenience. Everything it gets wrong inside those three becomes a wrong ID, and a wrong ID means a customer outage and a truck roll.

What every splice sheet needs

Two parts: a header that describes the job, and rows that describe the fibers.

The header

Each row

The part number line matters more than it looks. It's the one field that lets anyone regenerate the sheet later and get the same answer.

How to order the rows, and why fiber-number order beats tube order for the tech at the panel, is covered in the fiber splice color code guide. The closure side of the job (trays, slack, sealing) lives in the splice closure guide.

Build one in a spreadsheet

No special software required. Put fibers per tube in one cell (call it B1) and a 12-row color list in another range (Colors), in the standard's order. Then, for each fiber number in column A:

Fill down to the fiber count and the plan half of the sheet writes itself. Copy the block for side B, then add the blank columns for tray, loss and notes.

That's a perfectly good generator for a uniform loose tube build. It also fails quietly in four places, and each one has caught somebody:

Fiber 20 in a 24-fiber tube. The formula will write black with a black tracer, which can't be seen. On the 24-fiber builds the app carries, fiber 20 is black with a white tracer; some printed charts show yellow. Overwrite that cell with what the maker's sheet says.

Mixed tube sizes. One fibers-per-tube number assumes every tube is the same. Not every cable agrees. Some low-count builds on AFL's LE Series double-jacket sheet carry a 6-fiber tube alongside the 12s, which shifts every fiber after it. The AFL fiber cable configurations post walks through how far one maker's families differ.

Fillers. Fillers take a position in the stranding and carry no fiber. Count one as a tube and the sheet is off by a full tube from that point on.

Ribbon. Ribbon cable needs a ribbon number column, and fibers per ribbon aren't fixed at 12. Check the manufacturer's sheet for the exact part before you set B1.

Generate from the build, not the count

This is the one opinion worth holding firmly: a generator that only asks for a fiber count is the wrong tool, however polished it looks. Anyone tired of fixing sheets in the closure can usually trace the problem back to that one input box.

Take fiber 47 on a 144-count cable.

Same count, same standard, different strand. A sheet generated from “144F” alone will be confidently wrong on one of those cables, and nothing on the printout warns anyone. Some 144-count builds really are the second kind. If you've ever opened a closure, found six tubes where the sheet promised twelve, and suspected the paperwork, you were right to stop.

That's why the spec sheet comes first, then the formula. If the work order doesn't carry the part number, the reel tag or the sheath print usually does. And if the paperwork and the fibers disagree once the sheath is open, believe the fibers and fix the paperwork before cutting.

Plan sheet versus as-built

A generated sheet is a plan. It says what should be there. The filled-in sheet is the as-built record, and the two shouldn't be the same file without a clear line between them.

A few habits keep that line clean:

Loss thresholds and re-splice rules come from the job spec, not from the sheet template, so leave them out of the generator and put them in the header as a reference line.

Where the app fits

Fiber Optic Color Code Lookup doesn't build, store or export splice sheets. That part of the job is still a spreadsheet or paper, same as the tools in splice tech tools. What the app covers is the checking.

When a generated row and the strand disagree, forward lookup takes the fiber number and returns the tube color and fiber color for the standard and cable you've selected. Reverse lookup goes the other way: pick the tube color and fiber color you can see and get the fiber number back, without counting down a chart.

It carries 7 international standards (TIA-598-C, IEC 60304, DIN VDE 0888, S12, FIN2012, IEC 60794-2 and Type E) and 199 cable configurations, a mix of manufacturer-specific layouts from 6 manufacturers and generic standards layouts, with 98,898 pre-computed fiber lookups. The interactive cross-section diagram shows where each tube sits, which is the quickest way to catch a 12-versus-24 mix-up before it reaches the sheet.

It runs fully offline, so a vault with no coverage behaves the same as the truck. There's a 24-hour free trial with full access, then a one-time $4.99 purchase. Nothing recurring.

One caveat that applies to the app and to any generator: the answer is only as good as the build you pick. Choose the wrong configuration and the lookup will match the wrong sheet perfectly.

Frequently asked questions

What should a fiber splice sheet include?

A header with the job number, closure ID and location, closure type, cable IDs with fiber count, manufacturer and part number, color standard, date and tech. Then one row per fiber with fiber number, tube and fiber colors for both sides, tray and slot, splice type, splicer loss estimate, OTDR loss and notes for express, dead or reserved fibers.

Can a spreadsheet work as a splice sheet generator?

Yes, for uniform loose tube builds. Put fibers per tube in one cell and the 12-color order in a range, then calculate tube number, position and colors for each fiber number. Check four things by hand afterward: fiber 20's tracer in 24-fiber tubes, cables with mixed tube sizes, filler positions and ribbon builds, where fibers per ribbon aren't always 12.

Does Fiber Optic Color Code Lookup make splice sheets?

No. It doesn't build, store or export splice sheets. It's an offline lookup: forward lookup turns a fiber number into its tube color and fiber color, and reverse lookup turns the colors you can see into a fiber number. Use it to check rows on a sheet against the strand in your hand.

Why doesn't a generated splice sheet match the cable?

Most often the sheet was generated from the fiber count instead of the build. A 144-count cable can be 12 tubes of 12 or 6 tubes of 24, and fiber 47 lands in a different tube on each. Pull the manufacturer's spec sheet for the exact part number and regenerate the sheet from that.

Related