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.

PUK CSV Header Fixer

Upload a CSV to clean hidden header formatting issues. This fixes hidden non-breaking spaces and extra spacing in column names.

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

ALEA GROUP / CO & PROPOSAL TOOL

D-Tools Tax & Adjustment Checker

Step 1: Upload a "clean" screenshot (before new line-item adjustments are added) to extract current subtotals.
Ready for initial upload.
NET VALUES (FOR FINAL TAX RECONCILIATION)
INITIAL ADJUSTMENTS (TOGGLE TAX SYNC)
Check the box to include the adjustment in the Taxable Base (e.g., Small Parts).
Adjustment Name & Tax Status Amount
No initial adjustments detected.
RECOMMENDATION BASES (GROSS ADDITIONS)
Enter the positive value of the NEW items added here. This ensures your Small Parts & Logistics percentages calculate correctly.
ALEA Proposal Reviewer v2