Setup & Start
Pass: enid
CTRL + ;
Standards Expert
Gemini AIHello! I'm trained on your MTE PDF standards. Ask me about drafting Cell Towers, Mux tabs, or QC rules.
Smart Revision Log
Red Line Rules (Do Not Fail)
01
Don't Update Links
ALWAYS click "Don't Update" when opening Excel.
02
Clear Name Manager
Unprotect sheet (enid) -> Delete All Names.
03
The Scope Rule
Do NOT fix neighbor splices outside Work Request.
04
Password Protocol
Universal password: enid
Tool Installation
1. GPS Tool (Add-in)
\\cable\ncd-shared\misc\FiberLib6.82. Custom Ribbon
\\cable\ncd-shared\misc\CBH-MTE CUSTOM RIBBON.exportedUIWorkspace Naming
Symbol Dictionary
Cell Tower Standards
Multi-Provider: Link 2nd provider with 15' strand. Scale text up 100x. Use mdudet setup (AS=.001).
User Data: Slot 1: Provider, Slot 2: Site ID, Slot 3: Address.
Map Hygiene
- Fiber Spacing = width of telephone pole.
- At least one Fiber Count Circle per map.
- Riser Rule: Add 25' to first UG segment.
Physics & Terminology
Trunk (H/E): Light Source
Roots (Terminal): Customer Connection
Downstream/Forward: Trunk → Roots
Upstream/Return: Roots → Trunk
H/E Description Gen
Channel Ref
| 1 | CWDM-1510 nm (Low) |
| 2 | CWDM-1470 nm (Low) |
| 3 | CWDM-1490 nm (Low) |
| 4 | CWDM-1570 nm (High) |
| 1 | ITU20-1561.42 nm |
| 2 | ITU21-1560.61 nm |
File Hygiene
- ⚠️ Unprotect Workbook:
enid - ⚠️ Clear Name Manager: Delete ALL.
- 🔗 Sidecar Active links to H/E Col H.
Colors & Formatting
- ● Indigo: Sidecar Splices
- ● Lime: Node-feeding
- Line Width: 1.75pt leader lines.
Standard Visual Patterns
Terminal Splice
In
Color
Desc
12F
Blue
Jumper
Spl#
Orng
Address
Sidecar Mux
Filter
Color
Desc
1x8
(Rose)
Type B
Out
--
Open SC
Ring Cut
Fiber
Color
Status
--
Orng
= RING CUT =
Overlay Block Builder
5-Line RulePreview
ADDRESS
POLE#
SPL#
TOWN, STATE
Jumper vs Span Logic
1
Same Pole?
Yes = JUMPER
2
Same Building?
e.g. Garage to Floor 1 = JUMPER
3
Footage < 500 Feet?
"Rule of 500" = JUMPER
D36 vs Design Code Logic
2 or less missing:
Claim D36 (1 unit per missing splice).
More than 2 missing:
STOP JOB.
Contact Manager. Request D7/D8.
Billing Code Selector
Select a job type...
Troubleshooting
Excel Crashes
Cause: Corrupt Name Manager. Fix: Unprotect -> Delete All.
Splice Loops
Cause: Copy/Paste error. Fix: Check OVERLAY tab.