CREATING MAPFILES FROM EXEL CELL FILE:

Section Page 1 GROUP RESPONSIBLE................................................................12 MOP INFORMATION....................................................................22.1 BASIC MOP INFORMATION.......................................................22.2 CONVERSION OF CELL FILE TO MAP-BASED FILE.............23 AIM and REQUIREMENTS..........................................................24 STEP BY STEP GUIDE..................................................................4

Group ResponsibleThe following section is completed by Group Responsible only.

APPROVED? YES NO IMPACT RATING

LOW MEDIUM HIGH

DATE: 8/17/2010

TIME: 1:09 PM DIFFICULTY RATING:

LOW MEDIUM HIGH

APPROVER NAME:

SKILL LEVEL REQUIRED:

APPROVER PHONE: 1 2 3 4

MOP INFORMATIONSection 2 is to be completed by the performer. All the information in Section 2 must be filled in before submitting the MOP for review.

BASIC MOP INFORMATION

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Plano,

2. Requested by: Customer Project Manager Other

3. Prepared by: Aparna Srinivasan and Aarathi Mohandoss Company:

Ericsson Phone:

4. Submitted by: Aparna Srinivasan and Aarathi Mohandoss Company:

Ericsson Phone:

5. Scheduled Start Date:

6. Scheduled Completion Date:

Aim: Conversion of excel Cell Configuration file to Map-based MapInfo file:

Tools Required:

MapInfo 8.5 SiteSee 1.3

Requirements:

Cell Configuration file (sample included below)

This file contains just the format/template of how the cell file should look like. All the columns must match with the new cell file before the conversion process. The information on the cell file is taken from the RNDCIQ

Step By Step Guide:

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

1 Log in to MapInfo tool. License is required to use the tool. Click on the “open” icon.

2 Select the Cell file created with excel as the file type.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

3 Select “other” from the drop down.

4 Change the range A1 to A2. The data value is considered from the second row till the end. Give “OK”.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

5 Check the “Use Row above Selected Range for Column Titles” checkbox. And give “OK”.

6 The sheet behind will appear with all the data range that was selected in the previous step. Click on “Tools” -> “Run MapBasic Program”.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step DescriptionResponsible

EricssonCompleted Initial

Open the SiteSee application tool.

Click on “Table” -> WFI SiteSee -> Create Site Boundaries.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

7 In the SiteSee: Creating Site Table window:

Select the following:

Site table : Cell file (excel);

Site latitude from column: latitude

Site longitude from column: longitude

Select the checkbox “or use value” and give 0.18 “in miles” as the value for the label (this value can be adjusted to get a proper view on the map as required). This will inactivate the Site radius from column dropdown.

Check the “Use Site Sectorization” checkbox;

Select the checkbox “or use value” and give 35 as the value for the label (this value can be adjusted to get a proper view on the map as required).

Orientation from column: beamDirection.

Click “OK”

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

This will create the Site Boundaries.

Save the file as a Site Boundary file.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

Close the Cell file browser before proceeding with the Site Boundary file.

8 Open the saved “Site Boundary” file.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

Once the file is open, select the “Table” tab from the task pane and open WFI SiteSee -> Create Channel Labels.

In the window SiteSee: Creating Channel Labels: Select the Site Boundary file from the dropdown.Azimuth from Site: beamDirection; Distance Factor: 1.8 (this value can be adjusted to get a proper view on the map as required).First and Last Channel Column: PCI; Label Angle: 0 degrees.Click “OK”.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

Save the Channel label changes by going to Map -> Save Cosmetic Objects. Save it as PCI.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

9 Go to task pane and click on Table -> WFI SiteSee -> Create Site Labels.

From the window SiteSee: Creating Site Labels: Select Site Boundary file from the dropdown for Site Labels.Select Label Location: Top Center (however required).Distance Factor: 1.25 (this value can be adjusted to get a proper view on the map as required).Label from Column: eNBId (or the Site Name)Click “ok”.Save the Site label changes similarly going to Map -> Save Cosmetic Objects. Save it as “Site Id”.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

10 Select Table from the task pane and go to WFI SiteSee -> Create Sector Labels.

From the window SiteSee: Creating Sector Labels:Select Site label: Site Boundary file from dropdown.Sector Azimuth From: beamDirection;Distance Factor: 0.5 (this value can be adjusted to get a proper view on the map as required).Label from Column: Sector_ID (or the sector id).Label Angle: 0 degreesClick “OK”.Save the Sector Label changes going to Map -> Save Cosmetic Objects. Save the file as “Sector Id”.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02

Step Document Number and/or Step Description

Responsible

Ericsson

Completed Initial

11 The final MapInfo file will have all the Site Boundary, PCI, Site Id and Sector Id.

METHOD OF PROCEDURE

RF TUNING TEAM

Prepared (also subject responsible if other) No.

AARATHI MOHANDOSS & APARNA SRINIVASAN EUS – Plano TXApproved Checked Date Rev Reference

2011-16-02