S.No. FREQUENCY USER DATE TRANSLOC ADDRESS
(in MHz) (dd/mm/yyyy)
(Number) Numeric (17,8) Alphanumeric(60) DD/MM/YYYY Alphanumeric(20) Alphanumeric(300)
Note: Please note that the NEW fields added in the new format are marked with BLUE
IMPORTANT: Please don't use any custom made format for any column. Use only "General" format of Excel.
CITY STATE PINCODE LATITUDE LONGITUDE
(DDNMMSS,SS) (DDDEMMSS,SS)
Alphanumeric(25) Alphanumeric(45) Numeric (6)
Eg. 38N1224,30 Eg. 076E1741,00
ormat of Excel.
RECLOC RECLAT RECLONG ALTITUDE (In Mtrs) BLDG. Height
(DDNMMSS,SS) (DDDEMMSS,SS (In Mtrs)
Alphanumeric(20) ) Numeric Numeric(6,1)
Eg. 38N1224,30 Eg. 076E1741,00 Note: Give value Note: Give
without unit. Value value without
should be in Mtrs only. unit. Value
should be in
Mtrs only.
TOWER HT. Covrage DISTANCE EMISSION Transmitting POWER HOURS_Op
(In Mtrs) (In KMs) (in dBW)
Numeric(6,1) Numeric(6,1) ALPHANUM(9) Numeric
Note: Give Note: Give value Eg. 12M0F3E Note: Give value Eg. H24/HJ/HN
value without without unit. Value without unit. Value
unit. Value should be in KMs should be in dBW
should be in only. only.
Mtrs only.
ANTENNA Name MAX AZIMUTH ANT.GAIN (in ANT_ELVATION ANTENNA_HT CHANNELS
(0-359 DEG) dB) (-90 to +90 DEG) (In Mtrs)
ALPHANUM(50) NUMERIC(4,1) NUMERIC(4,1) NUMERIC(4,1) NUMERIC(6,1) NUMERIC(3)
Note: Give Note: Give Note: Give value Note: Give
value without value without without unit. value without
unit. Value unit. Value Value should be unit. Value
should be in should be in in DEG only. should be in
DEG only. dB only. Mtrs only.
REFERENCE NO. REMARKS
AND DATE
ALPHANUMERIC ALPHA(100)