One little wrinkle that has somewhat perplexed me ...
Example ... Cinema 132 is network 10 in the excel and shows as D10 1040. Since network 10 is usually D11, how do you know it's D10 1040 and not D11 1040. I know you have it correct, but how do you know it?
There's a few channels like that.
This is an instance of a 'redirected' channel. The data tells us that this channel is assigned as a part of Network 10, which normally would be D11 @99W. But the record also has a 'redirected' flag, indicating that this signal is actually being provided by resources within Network 15.
The record is assigned to TPN 2. In Network 15, data is provided by both D10 and D12. In this straightforward case, TPN 2 resolves the source as D10, since D10 provides TPNs 1 through 14 only, while D12 provides TPNs 9 through 24.
If the TPN for the redirection had been one which could be provided by either D10 or D12 (TPN 9, for example), we would go one step further and use the TID value to resolve whether this signal was from D10 or from D12.
Hope this helps.