TELECOM PROJECT

Hello


This project is perhaps the most popular among all other non voice form filling project across all over the world. I am getting a lot of hits from US, France, Germany and UK for this post.

I request you to avail my conversion service for this project as it would save your time, effort and resources. Not only this project, but for any other form filling project. Though those so called vendors would instruct you not to use any kind of automation tools to process the data, its impossible to accomplish the project with in the prescribed limited time frame and achieve the accuracy levels in traditional manual entry methods. So, they best method is to convert the data, verify the converted output in ms excel format for spelling errors and spaces errors and then dump the data directly from excel to client software/server..

Now let us have a look at a few screen shots.

Screen Shot-1: Telecom_Process_Sample_Image






Screen Shot-2: Telecom_Process_Sample_Form




Screen Shot-3: Telecom_Process_Instructions_Manual







    Now, We shall discuss all the fields in detail. Now, I will explain you how these fields were arranged in a specific order. You know that the Telecom Process Project's entered data will be saved in a rar file in VSofts or SSofts Folder in C Drive. Same is the case with Medical Sales Pro with a slight change in folder name. It would save as SSofts folder. If you already doing these projects and don't know how to check your work for errors, follow these simple steps. Create a new folder on your Desktop. Rename it as Quality Checking. Open C Drive/Vsofts and copy the rar/mdb file and paste it in to the new folder. Now, open it. It prompts you to enter a password. The Password for Telecom Process is ' dellentry1947Ajadi' and for Medical Sales Pro is 'ruralRular1947Ajadi'. Now, double click the form details tab, copy all (Ctrl+A, Ctrl+C) the form details or query 2 and paste the same in to an empty excel sheet. Press Ctrl+1, you would get format options pop window, press right arrow to open alignment tab and there uncheck the wrap text option. Select all and auto adjust all the columns. That's it.. That is your work. Now, you can check it for errors. Apply Filter and sort each and every field one by one, and look for those unique values mentioned below. All the extra values You would find are typing or copy N pasting errors.

Field Number 1(Entry No): denotes the Image or file number. At an average you will be provided with 140 Images or 180 Images.

Field Number 2 (Form No): indicates the form or record number from an Image File/Page.

Field Number 3 & 4(Invoice Number & Invoice Date): In any company, if they issue invoices with every sale, each day, then the lowest invoice number should begin at the start of a year and the highest invoice number should come at the end. But, as they arrange the data according to their convenience, this rule does not apply here. Invoice number can be anything and the invoice date can be anything. Another interesting fact is, all the invoicing dates will be within 12th of any month. As they provide you data in the form of DD/MM/YYYY and ask you to enter the data in MM/DD/YYYY format. This is just confuse the Data Entry Operator while entering the data and divert your attention while quality checking. In most projects, the invoice number will begin with (Tc_vd-Sdi-Oem-) followed by 5 or 6 numericals. Split this column into two with the above fixed term into one column and numerical values into another column, with the help of text to columns option in Excel (press Alt, A, E in sequence, and dont press and hold Alt key), select fixed width. Dont forget to check the text tick box in the next window, other wise zeros will be deleted in the numerical values column. It will eases your quality checking work.

Field Number 5: Phone Number: Phone numbers are same in all works. As we already knew, first three digits denotes the area of a phone number, no such relevance would be found in this work. You will find different area codes for the same area. To ease the quality checking, split this column into 7 separate columns. For example, if we split a phone number (123) 456-7890, it will be "(" ; "123" ; "456" ; "-" ; 7890. Select fixed width, apply these manual columns brakes, press enter, then select all the columns and check the text tick box, and press enter.. Thats it.. Ok?

Field Number 6: (Price Plans) will have 8 unique values

39

49

59

89

99

108

109 and

129

Field Number 7 (Device Name) will have 40 unique values

LG-B-2150

LG-B-250

LG-D-200

LG-D-300

LG-KG271

LG-P-2600

Motorola-E298

Motorola-Mpx200

Motorola-Mpx220

Motorola-Rqzr V3i

Nokia-2865

Nokia-3230

Nokia-3250

Nokia-5200

Nokia-6136

Nokia-6151

ORANGE spv-C500

ORANGE spv-C600

ORANGE spv-C700

SAMSUNG-C-300

SAMSUNG-D840

SAMSUNG-D900I

SAMSUNG-E250

SAMSUNG-E760

SAMSUNG-SGH-X-530

SAMSUNG-U600

SAMSUNG-X700

Siemens -CX65

Siemens -CX66

Siemens -D65

Siemens -SL65

Sony Ericsson-D750i

Sony Ericsson-D770i

Sony Ericsson-W300i

Sony Ericsson-W700i

Sony Ericsson-W710i

Sony Ericsson-W800

Sony Ericsson-W810i

Sony Ericsson-W880i

Sony Ericsson-W900

Field Number 8 (Phone Cost) will have only 3 unique values

FREE ON 9 MONTHS CONTRACTS

FREE ON 18 MONTHS CONTRACTS and

FREE ON 21 MONTHS CONTRACTS


Field Number 9 (Monthly Cost) will have 4 unique values

9

12

19 and

24

Field Number 10 (Free Minutes) will have 4 unique values

75

100

135 and

200

Field Number 11 (Free Texts) will have 5 unique values

250

300

350

500 and

600

Field Number 12 (Extra Value Included) will have 4 unique values

1/2 Rental for 3 Months

1/2 Rental for 5 Months

1/2 Rental for 6 Months and

1/2 Rental for 9 Months


Field Number 13: Customer Type: This field is extracted from Auto Sales Project, and there will be only 3 unique values

Business

Corporate and

Personal

Field Number 14 (Customer Name) is common among all kinds of data entry works. Although, these names would repeat in other nodes, we cannot say they are junk as the other details would change. You should pay a lot of attention to recognize the spaces between words and half (n) spaces between characters in a single word.

Field Number 15 (Initials) is to enter the first letter of each word and it is created for this work only. You should enter only first letters of different words in a name. You should not include single characters, ordinals such as I, II, III, IV, and prefixes such as Mr. Mrs. Sir, Dr and suffixes such as Sr. Jr. Br.and symbols such as (& " ' ` , #). To make this applying initials process pretty easy, please follow this procedure. Copy the Column A (EntryNo), Column B (FormNo),and column N (Customer name) fields into a new excel sheet. Select only column C, apply TextToColumns (Alt, A, E), select delimited, press Enter 2 times and go to the last options page, select space as a separation dellimeter and press enter. Now, you will find 5 to 6 new columns. Now, open FindNReplace (Ctrl+H), enter the above mentioned values that has to be excluded from being initialized and just leave the replace with dialogue box empty, press Ctrl+A to replace all. After completing all the replacements, you should create empty columns in between the existing columns. (if there are 5 columns namely (C, D, E, F, G) were created when you split the customer name field, then you should go to the d2 cell. Enter this formula  =LEFT(C2,1) which will extract the first letter from the left side cell. Copy this and paste till the end. Now, select entire column, copy, open paste special (Alt, H, V, S) and select values. Repeat these steps for the remaining columns. Now, delit the old columns except these newly created columns, as we extract the single alphabets from each of these columns as initials. Now, go to h2 and enter this formula {=C2&"."&D2&"."&E2&"."&F2&"."&G2&"." (You can add on or decrease this formula values as per the columns created, depending upon your work, but in the end you should close the formula as shown) and press enter. Now, copy this cell and paste into the entire column till the last row (go to B1 Cell, press Ctrl+DownArrow, now press right arrow to reach column H, press Ctrl+Shift+UpArrow, Ctrl+V). Again select the entire column, copy it (Ctrl+C), go to paste special option ( Alt, H, V, S) select values (3rd Option) and press enter. Thats it. Now, sort Column B first and then Column A, copy the Column H and go back to the previous sheet, goto initials column and select insert copied cells by right clicking in P2 Cell. You can now check with these news initials values with the old values.

Field Number 16 (Company Name) is extracted from Medical Sales Pro Project. In that project these names were listed as Courier Company names, but, in this project same values were listed as Company Names (God only knows, whether these companies were really exist) There will be 18 unique values

ANEXINET

ANVICOM

ARIES CARGO

BAE SYSTEMS

BLUE DART

DST INTERNATIONAL

ELECTRONIC DATA SYSTEMS

KELVIN DELIVATIVES

TAG ONLINE INC.

TANGOSOL INC

TD AMERITRADE

TELCORDIA

TELVENT

THE HARTFORD

THE MITRE CORPORATION

THE MUNICENTER

THOMSON FINANCIAL

WILLIAMS SCOTSMAN


Field Number 17 (Customer Address) is same as found in all works. There will be no unique values in this field.

Field Number 18 (Email) is also same as found in all projects. Interesting fact is, names and addresses may be same as there is every possibility in real. But, everyone knew that email id are unique and no 2 persons would possess the same mail id. You can check this field with the other nodes or slots of work, and you will find a lot of email id's are repeating. If your vendor asks you to remove the spaces, you can do it very easily. To remove the spaces in the middle, press Ctrl+H, in FindWhat dialogue box, give a space, and leave blank in ReplaceWith Dialogue box. Press Ctrl+A, twice or thrice till you get the zero replacements were made message. Now, to remove the trailing spaces (starting and ending spaces) insert a new column after the Email column, enter =Trim(C2) where is C is the column name and you can change it with column name in your workbook. Now copy it into the entire column, paste, and then select again, goto paste special (Alt, H, V, S) select values and press enter. Now, all the trailing spaces will be removed atonce. Delet the old email column now.
Field Number 19 (City) is a common field.

Field Number 20 (State) is also common. But, you cannot ask anyone that particular city is in some other state, but not as shown in a form. As I said already, you would not find anyone, even your vendor to answer your question. There are 54 Unique values in this field and you can download them online as it eats a lot of space here. Remember, this field should always contain only 2 alphabets.

Field Number 21 (Zip Codes) are pin codes of USA. You may wonder, when you see different zip codes for a city of a same state.

Field Number 22 (Residence Type) is extracted from Auto Sales Project. There will be 5 unique values

Apartment

Condominium

Duplex

Multi Family Home and

Single Family Home

Field Number 23 (Agent No) is extracted from Medical Sales Pro Project. There will be 13 unique values
A
AD
C
CA
CI
Q
QA
RE
TH
VG
W
YU
Z and
ZX

Field Number 24 (Agent Name) is also common in all projects. There will be no unique values in this field

Field Number 25 (Agency Code) is extracted from Medical Sales Pro Project. There will be 22 unique values

VD10ILI

VD10O00I

VD110I

VD200III

VD2102I

VD212O10I

VD213OI

VD214OI

VD222OO0I

VD234loI

VD24l0I

VD310I

VD3110I

VD3344III

VD34OI

VD3IOI

VD5O5I

VD65II

VD6O6I

VD7700IOOI

VDFFIOI

VDQQl20I


Field Number 26 (Agency Name) will have 24 unique values

BAYONNE Infocomm

Bayonne Telcommunications

BEST BUY #375

CALDWELL Communications

dumont Infocomm

EAST ORANGE Services

FORT LEE Communications

Fowlerville Communications

Jersey Services

leonia Services

Lincoln Park Services

LITTLE FERRY Telcommunications

MESA PHOTO ARTS, INC.

Montvale Services

new milford Communications

North Reading Services

OAKLAND Services

RITZ CAMERA #923

River Edge Communications

TAOS MOUNTAIN ELECT., INC.

THE MOBILE SHOP

Union Services

West Milford Services and

west new york Communications

Field Number 27 (Deposit) will have only 2 unique values

200

250

Field Number 28 (Balance) will have only 2 unique values

350

400

Field Number 29 (Credit Card Type) will be found in all kinds of form filling works with the same 4

MasterCard Gold Card

MasterCard Titanium

MasterCard - Platinul Plus

Visa Gold Credit card and

in one form you will find CREDIT CARD TYPE as another unique value.

Field Number 30 (Credi Card Number) also common among all works. But, the interesting feature is these credit card numbers would repeat in each node, twice or thrice with different customer names, addresses, city and zip codes.. That means, (perhaps in the US, as we don't know exactly about how they issue credit cards) 2 different persons were having 2 cards with same numbers..Ha..Ha..

Field Number 31 (Card Expiry Date) is extracted from other projects. Actually it is not card expiry date. The biggest blunder they made while creating these data bases is, a single credit card number, which repeats twice or thrice in a node, would belongs different types and will expire in different dates. They could have been taken a little bit extra care while making this junk database files..

Field Number 32 (Credit Rate) is extracted from Auto Sales Project and will have only 4 unique values

Excellent

Fair

Good and

Poor



(to be continued)