CellRam Version 4.9.1.0 release

FEATURE LIST

1) New PTN only account access: Simply type a PTN and the BAN appears.

2) New Name only account access: Simply use Name Search to get PTN and BAN

3) New secure reporting systems make it easy to pull your accounts and assist in mailings and other marketing efforts.

4) New Eligibility Lookup Systems extract eligibility information. Easily Obtain updated eligibility dates on accounts and large multiple account unit lists.

5) Dated folder lookup storage - proof of eligibility pages are securely stored in dated folders. This means that running the Wizard on an account will not overwrite previous files; it will make a new folder for the new data.

6) Improved web control functions with extensive error checking and site problem automatic resolution.

7) Faster login functions, account lookup procedures, and dialog control systems.

8) Enhanced security.

9) New Monthly Eligibility report systems – Fast, Easy, and reliable. Offers amazing sales opportunities. See the Monthly Eligibility List function below.

10) When a single ISC lookup is performed, a list of all PTNs is stored for Eligibility tracking and reporting. These stored lists will become part of your Wizard database.

New Monthly Eligibility List function

NOTICE: THIS IS NOT FOR CORPORATE ACCOUNTS! This function is for individual and business upgrades ONLY - Eligibility data for CORPORATE accounts is only available on ISC that will produce a “Full Worksheet”

This new Eligibility List function is designed to enhance the “Run Account Group” function. The Run Account Group function is still available - a Full Worksheet is required for Corporate, Government, and some other account types.

The New Eligibility List function will obtain current upgrade eligibility status for 1000’s of units at a time – an automatic goldmine for dealers. There is almost NO TIME INVESTMENT to obtain current eligibility status for large lists of units. Just start it and it runs through all units. It will run the complete lead list in a single function. A single spreadsheet is created listing all units with updated eligibility information. Corporate unit data will be skipped by default.

SPECIAL NOTES:

· This procedure runs in the background so the machine is available for other use.

· This procedure is available for use 24 hours a day and can be started at night just before closing.

· No web site logins or image text entry required.

· This procedure will function in a machine without a certificate.

HOW TO USE THE NEW ELIGIBILITY LOOKUP FUNCTIONS

1) Extract a lead list – or open an existing lead list.

a. This is the same function from previous versions.

b. Maybe best to create a new Lead List. Use 150 Eligibility and set dates like: 1/1/09 to (today’s date).

2) Click “Lookup Systems” button at the bottom right of Wizard Menu

New button name: “Run Account Group” is now “Lookup Systems”

1) New dialog lookup Systems

Click # 1 for new function (not for corporate accounts)

2) New menu ‘Unit List Lookup Controls’ (the color will vary)

3) Information about the Unit List Lookup Controls above

a. Unit List Settings: Start ~ Stop settings is used to start the lookup at a higher number in case some units were already looked up.

b. Set Target Account Size: Minimum ~ Maximum Account quantity of units limits the search to accounts that have a quantity of lines within the range you set here. If the default settings of 1 to 25 are used; units from large accounts (over 25 units) are not included.

c. Account Type / Store Proof: it is best to leave ‘Skip Corporate Units’ selected. Eligibility lookups will NOT be performed on Corp units. If it is cleared, Corp unit data will appear on the sheet – all unit data will be extracted from the Wizard database - this data is from the last ISC lookup (see “Data Date” field on sheet explained below).

d. Limit by Zip Code or Zip Range will limit the amount of units looked up to the zip codes you select. Leave the fields blank to include all zip codes available.

e. This procedure does not perform any ISC lookups. All data other than eligibility information is from the Wizard Database and may be from a previous lookup.

f. This procedure will run and generate a “UNIT ELIGIBILITY LIST” spreadsheet containing all accounts and units run.

g. Click “Run Eligibility List” button at the bottom right.

h. This dialog will show lookup progress:

4) The UNIT ELIGIBILITY LIST spreadsheet will appear (New report)

a. Click the “Elig Code” column heading to view proof of eligibility for each unit.

b. Click the “Open CellRam” to Launch CellRam – if it’s already running, it will come to the front.

c. Click the “DIRECT MAIL LIST Link” to view a stored a list of all required mailing address information for all accounts with 150 eligible units. This list contains units included in this run based on settings. Each procedure creates a dated file name and also uses the total unit quantity from the source lead list in the name. Sample filename: ‘01_01_2010_3129_Elig_150_Direct_Mail_List.txt’

d. Eligibility Dates are current -The “Data Date” field tells user when other customer data was collected. If there is no date – it’s from before March, 2009.

e. As you can see, the system ran 136 units in 15 minutes. This includes saving all search results pages to hard drive and generating the report.

f. NOTICE THAT THERE ARE NO ACCOUNT NUMBERS (for security).

The account numbers are no longer needed for units already looked up, just type a PTN into CellRam and the BAN will appear.

g. Additional unit results

h. “Bad PTN or Zip” usually means the PTN is inactive for this carrier.

i. “Bad Zip” usually means the PTN is active, but the zip is not. This data is saved so it can be run on SNAP or ISC at a later time (this feature will be available soon).

j. “Special Discount” is also a flag from the lookup results (not shown)– (employee – friend etc)

HOW TO VIEW ELIGIBILITY LISTS

Access to view Unit Eligibility lists and account report list spreadsheets is Password Protected

To view existing account lists:

Select the “Display Account List” Check Box upper right of the Wizard Menu

The List Access Password dialog will appear.

The default Password is your ISC Login password

Type your ISC login password and click OK or press Enter. If the password is correct, the Account Call Schedule heading will change to “Account Lists” and you will see all the account lists you have generated. Open them in the same way you would open and account spreadsheet; Highlight the sheet name and click “Open Selected Sheet.”

Once you have entered the correct password, access is granted until CellRam is closed.

NEW FUNCTION TO GENERATE ACCOUNT LISTS

These new functions permit you to extract customer information from your Wizard database and generate Excel worksheets.

To generate account list sheets:

From the Wizard menu, click “Database Menu” right side in blue

In the Database Menu, select the “YES” radio button under the “Generate Account List Sheets” heading.

See bottom left below.

If you are prompted for a password, enter your ISC Login password. (Same as Access to view Unit Eligibility lists above)

Check the type of accounts you wish to generate reports for in the “Select Account Types” section as shown above.

Click the green “Generate List and Reports” button

Dealing with lookup site errors & using the "GET LAST" button

For most web site errors, the Wizard will automatically navigate around the error, dismissing warning pop-ups and continuing to look up units.

For major site errors, the Wizard will automatically recover; saving the units looked up so far. It will navigate back to the 'Image Text'. You can input the image text and continue to run the remaining units.

For total shutdown of the Wizard, the Wizard will save the units looked-up so far. You can then re-start the Wizard and instruct it on which unit to re-start at.

If 49 units were looked up of 100, you can re-start the Wizard to lookup units 50 ~ 100. See complete instructions below.