Revised Counter 20260316

PUK Bill of Materials Review — CAT6 Counter (CSV)

Upload a CSV (raw BoM or previously exported CAT6 breakdown CSV)

Total CAT6–
POE CAT6–
Non-POE CAT6–
Unassigned–

Switch & Rack Recommendations

Upload a file to see recommendations.

Rules

Display & Deluxe Display default to 0 POE + 4 Non-POE per display. You can change POE designation per drop type below; we never change total CAT6 per row.
“Custom (k POE per drop)” is clamped to the number of CAT6 in each row.
  1. AP / Interface / Surveillance → POE by default
  2. Display / Deluxe Display → 0 POE + 4 Non-POE (flag if not 4 in the row)
  3. Tel/Data, Demarc, Satellite → Non-POE
  4. Unknown → Non-POE (flagged for review)

All processing happens in your browser. No data leaves your site.

Wire Schedule Generator

Wire Schedule Generator

Input: CSV exported from the CAT6 counter tool. Output: patch-panel landing plan + switch summary. Missing room numbers are tagged with TBD##.

Device preferences

Choose a preferred enclosure for a device class. The generator will try to keep rooms together, but will spill to the next compatible enclosure if needed and flag the preference break.

Spare wire rules

Mark specific wires inside a drop as spare tails. Example: AP D2 can be marked as a spare, grouped with other spare tails, and noted as Leave disconnected while still landing on a patch panel.
Colorado Tax Adjustment Tool
Colorado tax adjustment

Get the tax adjustment right the first time.

Enter the current values, choose whether your target tax comes from a desired final amount or from a tax rate, and the tool calculates the exact adjustment needed to land on the right final tax.

Main formula Target Tax − (Current Tax + Current Adjustment)
Optional lookup Verify Colorado tax by address
Designed as a single-file tool for easy hosting. This version keeps the workflow simple and computes target tax directly from Product Total and Tax Rate.

Inputs

Use the signed amount exactly as it appears in your process.
This calculates target tax as Product Total × (Tax Rate / 100).
Formula used Target Tax = Product Total × (Tax Rate / 100) Tax Adjustment = Target Tax − (Current Tax + Current Adjustment)

Result

Tax Adjustment to Enter
0.00
Computed target tax
0.00
Implied current tax rate
—
Final tax after adjustment
0.00
Difference still remaining
0.00
Calculation detail
This version keeps the workflow simple: enter Product Total, Current Tax, Current Adjustment, and Tax Rate, and the tool calculates the target tax and required adjustment automatically.