FDDLTE邻区参数一致性核查工具V1.1

1、按模板填写工参信息表，注意表头对应，涉及到eNodeBID\CellID\PCI\TAC等数值表格一定要准确；2、将网管导出的邻接小区和邻区信息表按格式粘贴到对应的ExternalEUtranCellFDD(外部小区表）和EUtranRelation（邻区关系表）表中，注意粘贴到第二列后面，因为第一列和第二列有公式一定不能删除；3、工参、邻接小区和邻区信息表都对应好之后直接查看Result（邻接小区-邻区关系参数一致性核查结果），注意第一列和第二列不要删除，如果结果不够则直接下拉即可；4、查看核查结果三个核查结果筛选错误的即是对应的参数不一致，根据前面源小区CI和邻接外部小区CI即可知道哪个外部小区或者邻区有错误；5、本工具目前只能核查外部小区TAC\PCI和邻区的用户标识，后期会增加核查、核查冗余邻区、邻区条数过多、单向邻区等功能；6、本工具仅使用了简单的几个公式，主要是为了方便核查邻区的初学者，因作者想法多，但excel版本更新记录2015/10/12FDDLTE邻区参数一致性核查工具V1.0提出初步构想2015/11/25FDDLTE邻区参数一致性核查工具V1.1编辑出V1.1版工具……FDDLTE邻区参数一致性核查工具Vn.n后续更新，功能完善问题1、核查外部小区TAC和PCI出现全部都是错误；解决方案：注意ExternalEUtranCellFDD(外部小区表）和EUtranRelation（邻区关系表）eNodeBFDDLTE邻区参数一致性核查工具V1.1使用说明LTECIRATType[LTETDD,LTEFDD]ManagedElementIDValuerange:[0~4294967296]eNodeBNameeNodeBIDeNodeBtypeLTECIRATTypeMEIDeNodeBNameeNodeBIDeNodeBtype82198_48LTEFDD82198XXSQ泰龙洗浴-F-DX8219882198_49LTEFDD82198XXSQ泰龙洗浴-F-DX8219882198_50LTEFDD82198XXSQ泰龙洗浴-F-DX8219882351_48LTEFDD82351XXXL东山2-F-DX8235182351_49LTEFDD82351XXXL东山2-F-DX8235182351_50LTEFDD82351XXXL东山2-F-DX8235182334_48LTEFDD82334XXXL东山1-F-DX8233482334_49LTEFDD82334XXXL东山1-F-DX8233482334_50LTEFDD82334XXXL东山1-F-DX8233482334_51LTEFDD82334XXXL东山1-F-DX8233482334_52LTEFDD82334XXXL东山1-F-DX8233482334_53LTEFDD82334XXXL东山1-F-DX8233482368_48LTEFDD82368XXXL沙地房-F-DX8236882368_49LTEFDD82368XXXL沙地房-F-DX8236882368_50LTEFDD82368XXXL沙地房-F-DX8236882368_51LTEFDD82368XXXL沙地房-F-DX8236882368_52LTEFDD82368XXXL沙地房-F-DX8236882368_53LTEFDD82368XXXL沙地房-F-DX8236882252_48LTEFDD82252XXSQ东榆林L-F-LT8225282252_49LTEFDD82252XXSQ东榆林L-F-LT8225282406_48LTEFDD82406XXXL太师湾-F-DX8240682406_49LTEFDD82406XXXL太师湾-F-DX8240682406_50LTEFDD82406XXXL太师湾-F-DX82406eNodeBLongitudeeNodeBLatitudeCellNameCellIDValuerange:[0~255]eNodeBLongitudeeNodeBLatitudeCellNameCellID106.913722.71305SQ泰隆洗浴H-048106.913722.71305SQ泰隆洗浴H-149106.913722.71305SQ泰隆洗浴H-250106.946722.6934XL东山2H-048106.946722.6934XL东山2H-149106.946722.6934XL东山2H-250106.944422.7022XL东山1H-048106.944422.7022XL东山1H-149106.944422.7022XL东山1H-250106.95922222.70068XL草帽山隧道北口H-051106.95922222.70068XL草帽山隧道北口H-152106.95922222.70068XL草帽山隧道北口H-253106.92118122.692987XL屈家庄H-048106.92118122.692987XL屈家庄H-149106.92118122.692987XL屈家庄H-250106.91644622.69873XL沙地房H-051106.91644622.69873XL沙地房H-152106.91644622.69873XL沙地房H-253106.965122.7182SQ东榆林LH-048106.965122.7182SQ东榆林LH-149106.928822.6826XL太师湾H-048106.928822.6826XL太师湾H-149106.928822.6826XL太师湾H-250CellLongitudeValuerange:CellLatitudeValuerange:[-90.00000ActiveStatusValuerange:TrackingAreaCodeValuerange:[0~65535]PhysicalCellIdentityValueBandIndicatorforFrequency[SpecialBand:0FDDScope:1-14,17-19,21-28,DownlinkSystemBandwidthValueDownlinkCenterFrequencyStep0.1MHZCellLongitudeCellLatitudeActiveTACPCIBandIndicatorforFrequencyDownlinkSystemBandwidthDownlinkCenterFrequency106.913722.7130551302143151867.5106.913722.7130551302133151867.5106.913722.7130551302153151867.5106.946722.6934514133151867.5106.946722.6934514143151867.5106.946722.6934514153151867.5106.944422.70225141963151867.5106.944422.70225141973151867.5106.944422.70225141983151867.5106.95922222.700685141813151867.5106.95922222.700685141823151867.5106.95922222.700685141833151867.5106.92118122.6929875141483151867.5106.92118122.6929875141493151867.5106.92118122.6929875141503151867.5106.91644622.69873514193151867.5106.91644622.698735141103151867.5106.91644622.698735141113151867.5106.965122.71825130243151867.5106.965122.71825130253151867.5106.928822.682651412103151867.5106.928822.682651412113151867.5106.928822.682651412123151867.5UplinkSystemBandwidthValueUplinkCenterFrequencyStep0.1MHZUplinkSystemBandwidthUplinkCenterFrequency151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5151772.5核查用勿删核查用勿删ResultMODINDSubNetworkMEIDResult操作指示子网ID管理网元IDS:SuccessF:FailA,D,Mlong:[0..999999]long:[0..999999999]源小区CI邻接外部小区CIA:增加，D:删除，M:修改，P:忽略子网标识网元的唯一标识，用于区分不同的网元。PrimaryKeyPrimaryKey82198_4882334_481307018219882198_4982334_491307018219882198_5082334_501307018219882252_4882334_481307018225282252_4982334_491307018225282252_5082334_501307018225282252_5182334_511307018225282252_5282334_521307018225282252_5382334_531307018225282406_4882334_481307028240682406_4982334_491307028240682406_5082334_501307028240682351_5382334_531307028235182351_4882334_481307028235182351_4982334_491307028235182351_5082334_501307028235182351_5182334_511307028235182351_5282334_521307028235182368_4882334_481307028236882368_4982334_491307028236882368_5082334_501307028236882334_4882406_481307028233482334_4982351_491307028233482334_4982406_491307028233482334_5082351_501307028233482334_5082406_501307028233482334_4882368_481307028233482334_4982368_491307028233482334_5082368_501307028233482334_5182368_511307028233482334_5282368_521307028233482334_5382368_531307028233482334_4882252_481307028233482334_4982252_491307028233482334_4882198_481307028233482334_4982198_491307028233482334_5082198_501307028233482334_4882351_4813070282334______________________________________________________