ias

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Introduction







The Industry Analysis Service presents reliable, regular and comprehensive analysis for the entire

range of industries. The offering comprises a beautifully produced report, replete with clear statistics,

elegant charts and incisive analysis, a CD containing the database used in the report and the report itself

in pdf formats. All packaged into a specially developed software which gives you the power to take the

data and the analysis further into your applications.







The reports analyse in detail, the demand-supply position and price movements to etch out the possible

future scenarios. The detailed data presented and analysed in this respect include production, exports,

imports, consumption, and domestic and international prices. The report presents monthly time-series on

each of these for three years. The items are further disaggregated by region, varieties, markets, etc. to

present a comprehensive and detailed view of the industry.







The analysis integrates quantitative information along with news and events in the industry. It

encompasses policy changes and important announcements, if any, from the government or industry

leaders.







We believe that any industry analysis is incomplete without a study of the performance of the present and

future enterprises engaged in the industry. The service thus includes a perceptive analysis of the growth

and profitability of the major companies as also the returns-risk profile obtained by them on the bourses.

The performance of the companies is integrated with the scenario emerging from the larger sectoral

statistics. Similarly, it incorporates the information on new projects on hand to present the prognosis for

the future.







The Industry Analysis Service draws upon the large and integrated databases of CMIE as also the

institution's expertise of over 25 years in monitoring the Indian economy.







The Industry Analysis Service includes a specially developed software which provides the entire

database used in the preparation of the reports. The database includes all the historical statistics and

more. It includes a longer time series and also higher frequency data than the reports contain. The

software enables the further analysis of the data.



The reports themselves are also available in pdf formats for you to view, copy, print and use further in

your reports.









Page 1

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









Page 2

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Using Industry Analysis Service







Use the Industry Analysis Service Installation and Update Instructions Booklet, enclosed alongwith

the CD, to install the product. The CD consists of both, the Standalone and Server installations.



You may install the Standalone Version on your PC's Local Hard Disk or the Server Version on your

Network depending on the version you have subscribe to.



After the installation process is complete, use the Industry Analysis Service Standalone Installation by

executing the Application shortcut.



For using the Industry Analysis Service Server Version, you need to execute two applications. The

Industry Analysis Service Client and the CMIE Product Server Server.



The CMIE Product Server needs to be kept running, while Industry Analysis Service Clients

are accessing the product. The Server Application has to run on a computer, accessible from across the

network.









How to use the CMIE Product Server Application?



How to setup the Client Access across the network?









Page 3

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





How to use CMIE Product Server







After running the setup, you should send the clkey.txt file (which is in product directory, for example

c:\cmie\ias\clkey.txt) to CMIE to get verified signature of the product.



Along with the VFSign you will also receive a server.ini file from CMIE.



For using Industry Analysis Service across the network, the CMIE Server Application needs to be

executed to service Client access.









Running the CMIE Products Server for Win9x



Running the CMIE Products Server for Win NT/Win 2000/Win ME /Win XP









Page 4

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Running the CMIE Products Server for Win9x







The VFSign has to be copied to Product.ini file in the product directory and server.ini file should be

placed in the same location where server.exe file of the product server is installed.



Once the server.ini file is in place, run the server.exe file to start the CMIE Products Server. This server

keeps a log of all the users accessing CMIE products.



On execution, the CMIE Server Application Window comes up and while clients access the Industry

Analysis Service application, it displays the following information:

 Seq: Sequence of users logged in.

 pr: Refers to the product being accessed. For Industry Analysis Service the abbreviation,

"prow" is displayed.

 cl: The user's machine name.

 t-init: Initial time of Industry Analysis Service startup by the user.

 t-last: Time of latest verification of Industry Analysis Service .









Page 5

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









To change the Port number:



You may need to change the Port number (Port Number of the PC running the Multi User Application)

for better communication with clients accessing the Industry Analysis Service application. 1500 is the

default Port number used by the Multi User Application.

 Click on the Change Port text box and enter the new Port number.

 Click on Restart. This will restart the CMIE product Server in order to implement the new Port

number.

Note: In such cases the Port will also have to be changed in the Product.ini file on the network.

 Click on Close Service, if you need to stop client access to the Industry Analysis Service

Application.

 Click on Minimize to hide the CMIE Product Server Window display. Click on the Server icon in the





Page 6

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





System Tray to display the Window again.









Page 7

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Running the CMIE Product Service for Win NT/Win 2000/Win ME/Win XP







The VFSign has to be copied to Product.ini file in the product directory and server.ini file should be

placed in the system32 folder within default windows directory. So for winnt it could be

c:\winnt\system32



Once the server.ini file is in place, go to the Control panel, Administrative Tools, Services and click on

the service named "CMIE multi product licensing system" and click on the Stop button. Once the service

stops, click on the Start button.









To view the list of users accessing the product click on the clviewer.exe shortcut called "CMIE Products

User Viewer". You can minimise or close this application as this is just a viewer application and not the

service which authenticates the user.









Page 8

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









Page 9

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





How to setup a PC to access IAS server installation





 Setup a client (a computer on the network) to access Industry Analysis Service Application (for

Multi-user installations)

 From the computer, run setup from the client directory within the IAS directory (For example:

F:\cmie\IAS\client) created on the server during the server setup.

 A Licence Agreement will be displayed after which the setup will prompt you for User and Company

Name.

 Next, setup will prompt you for destination location for IAS temporary files. The default path given is

C:\Program Files\CMIE\IAS which can be changed.

 In the next screen displayed, check all the selections done in the previous steps from the confirmation.

If you wish to change any of these then use the Back button to do so or else continue with setup.

 Setup will now try to install HTML Help(R) on your computer. Installation will be skipped if the

software exists or a newer version is found. Complete the installation on the next screen by clicking on

the Finish button.









Page 10

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





When You Begin







The startup screen of the product is that of the Query window. You can click on the any of the Launcher

Toolbar Buttons, representing the modules available, to begin using the IAS package. Click on any of the

launcher buttons



and the Query option buttons



shown in the picture below to get more details.



Before you start using the features in Industry Analysis Service , use the Settings option by clicking on

this toolbutton or selecting the Settings option from the View Menu. Industry Analysis Service

allows you to customize certain program settings as per your requirement.



















Page 11

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Settings







This utility allows you to change the default program settings according to your requirements.









The various options available in this are:



Output Sheet



Allows you to change the following settings:



 Date Format



 FontName



 FontSize



 Gridline: Show/hide grid lines.



 FontColor1: First colour in alternating row display in Output Sheet



 FontColor2: Second colour in alternating row display in Output Sheet



Database



Allows you to change the following settings:



 DBpath: Default database path.



 PDFpath: Default path for all data regarding the PDF documents.



Chart







Page 12

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Here you can specify:



 Type: The default chart type whenever the Chart Assistant is initiated.



 SeriesIn: The default selection of whether the data is in rows or series.



 BackColor: Set the background colour for the chart.



Select Indicators



Here you can specify the default output format for the query:



 Ind x Dt: Information on each indicator will be displayed row-wise.



 Dt x Ind: Information on each indicator will be displayed column-wise.



Toolbars



The list of toolbars that can be selected can be specified here.



Messages



Allows you to change the following settings for CMIE broadcast messages:



 Show on startup: If selected, shows the broadcast messages by CMIE everytime you run the

software.



 Last update: Stores the date when last update was performed for the database.



Batch



An added facility Batch/Planner to re-run a particular query is also available. For this Industry

Analysis Serviceallows to to specify a description to 10 batch files at a time which you may always

require to utilise. For this click on any one of the rows, specify the desciption of the batch file and give

the filename given to the batch file. You can access this batch file from the Batch runner toolbutton in the

Tools Tool Bar or Menu from within Industry Analysis Service .



Report



Allows you to change the following settings for reports:



Printcolor



If selected, prints coloured reports.



FullScreen



If selected, shows the report in fullscreen.



Notes



Industry Analysis Service offers a utility for recording your observations, analysis or information on a

particular indicator included in the application. This information is classified by Indicator, Date, Author









Page 13

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





and Headings in a notes file with a "not" extension. Enter your default notes filename which will be used

to save and display all the indicator notes written on your PC. You can also change this filename later

for the sake of convenience. Remember to always enter a filename with the "not" extension, like

"notes.not" which is entered by default.









Page 14

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Launcher







The following are the main modules of Industry Analysis Service , which are accessible from the Launcher

Toolbar and Menu.









Page 15

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Query







The Query Window will be displayed when you click on the Query tool button or select the

Query option from the Launcher menu.



On completion of a search, the results are displayed in the Output Sheets. The data selected up to the

last execution of the search is displayed in the Output Sheets, along with the values of parameters on

which the search was performed. Information provided in the Output Sheets can also be further

processed.









Page 16

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Operating Guidelines







While running a query, there are a few basic fundamentals and operations one needs to know to get

maximum mileage out of the Industry Analysis Service software package. They are:

 Basic and Compound Queries

 Execute Commands

 Structured Selection

 Expression Based Query

 Expression & Unit Headers

 Arithmetic Operators and Functions

 CMIE Sets

 User Sets

 Tools Available









Page 17

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Basic and Compound Queries





 A query consists of a set of conditions that the indicators should meet to qualify for selection.

 A query can be a simple single step search or it can be complex with several searches linked to each

other.

 A compound query can be simplified into several basic queries by linking them with Logical Operands

-- AND, OR, NOT.

 Executing a Basic Query leads to the selection of a set of indicators which satisfy the conditions set in

the query.

 The result of a query is displayed in the Output Sheets.

 AND, OR, NOT are logical operands are used on the set of marked indicators to enlarge or reduce

the set.









Page 18

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Execute Commands







Described here is the list of execute commands available in Industry Analysis Service.









OR









Example:



 SETONE could be a set of indicators (A,B,C,D) selected in the Select Indicators Window.



 SETTWO could be a set of indicators (D,E,F,G) in the Output Sheets arrived at by running a query.



The selection of SETONE OR SETTWO leads to the selection of all the indicators which exist either in

SETONE or in SETTWO. Indicators are not counted twice if they exist in both sets. Thus, on selecting

SETONE OR SETTWO, a full set of indicators is obtained (SETNEW) belonging to both the sets, i.e.

A, B, C, D, E, F and G.



Thus the OR execute command is "expansive'' or "inclusive'' in nature. By using the OR command on

two sets we obtain a set which includes elements of both the sets. The set thus obtained would be larger

than the sets on which the OR command was used if the two sets are not identical.



Thus, in Industry Analysis Service if a set of indicator is already selected and the search is continued

using the OR operand, then the set of indicators selected would increase. The only exception to this rule

would be if the further search does not lead to the selection of any indicator that is not already selected.



Note:



 For running the query for the first time, use the OR Execute Button.



 SETONE OR SETTWO gives the same result as SETTWO OR SETONE.









Page 19

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









AND



Example:



 SETONE could be a set of indicators (A,B,C,D) selected in the Select Indicators Window.



 SETTWO could be a set of indicators (D,E,F,G) in the Output Sheets arrived at by running a query.



The selection of SETONE AND SETTWO leads to the selection of indicators which exist in both,

SETONE and SETTWO. Thus, on selecting SETONE and SETTWO, we get only D.



Note:



 The AND operand is restrictive because, it requires multiple conditions to be satisfied. By using the

AND operand on two sets we obtain a set which includes elements which are common to both sets.

The set thus obtained would be smaller than the sets on which the operand was used if the two sets

are not identical.



 A null set AND a non-null set is a null set. There is nothing common between a null set and a set of

indicators. Therefore if the indicators selected before doing a search is 0 and the logical operand is

set to AND, the result of the search will necessarily be zero.



 SETONE AND SETTWO gives the same result as SETTWO AND SETONE.









Add Col









Page 20

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





This command can be explained with the help of the following example:



Consider you have a list of indicators.



You want to perform a expression based query on the list to show indicators with total income > 100

(Rs. '000). You would choose the AND command to filter out your list.



Now, the AND command will keep only those indicators in the list which satisfy the criteria.



To retain those indicators in the list that do not satisfy the criteria, use the Add Col command button.

NOT



Example:



 SETONE could be a set of indicators (A,B,C,D) selected in the Select Indicators Window.



 SETTWO could be a set of indicators (D,E,F,G) in the Output Sheets arrived at by running a query.



The selection of SETONE NOT SETTWO leads to the selection of indicators which exist in SETONE

but excludes the ones existing in SETTWO. Thus, on selecting SETONE NOT SETTWO, we get A, B

and C.



If the NOT operand is used on two identical sets of indicators, the result will be a null set of indicators.



Note: While SETONE NOT SETTWO gives A, B and C, SETTWO NOT SETONE gives E, F and

G.









New









Page 21

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Performs an OR Query on the specified criteria but gives the output in a new Output Sheet.

Remove



Removes selected indicators from the Output Sheet.









Page 22

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Structured Selection







The Industry Analysis Service database has classified and organised all the indicators on sectors like

Sugar, Petroleum etc. into a structure to facilitate efficient search processes and selection.



The classification structure can be visualised like a tree with several nodes, branches and leaves.



 Nodes are broad headings which further branch out to more nodes or leaves. The sign before

an indicator denotes a closed Node and the sign indicates an open Node.

 Leaves are end indicators in the tree structure. These are indicated by the sign before an

indicator.

 There is no further classification to a leaf indicator.

Example: Consider Textiles to be a node consisting of several nodes representing Spun Yarn, Fabrics

and International Trade data. Spun Yarn themselves are nodes which branch out to further indicators like

Demand Supply, Despatches and Stocks. Thus, all the indicators on Textiles are classified into a

top-down tree structure beginning with the products like Spun Yarn and Fabrics. This sprawling

classification structure of indicators is used in the database in defining the Industry Sectors.







The Indicators list provides a Tree view with an Embedded search box to search for a text string in an

Indicator in the Indicators Tree. This is available just below the Indicators Panel in the Select Indicators

Window.



Another type of a Structured classification system in Industry Analysis Service is the Expression List.

This is viewable by clicking on the Select Expression button in the Advanced Options-Query option.





This type of Structured Selection provides you two types of views for navigation:



Tree View



 This view gives an expandable tree structure.

 Selection can be done by marking the check box with a single mouse left click. This click is a toggle

to mark and unmark.

 A Ctrl + single mouse left click selects all the indicators within a node.

 An Embedded Search can be performed on the indicators in the tree view.

Embedded Search



The embedded search feature searches for the string you have typed in the whole indicator list and finds

the indicators that contain the search string. The search string here may not necessarily be in the

beginning of each indicator as in the auto search.







Example: To search for the word cement in the list of indicators, enter "cement" in the search box and

it will find all indicators which have the word "cement" in them.









Page 23

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





List View

 This view displays an unstructured list of all the indicators of the query parameter that you have

selected.

 To expand the List View, right click on the mouse and select the required level.

 Selection can be done by marking the check box with a single mouse left click. This click is a toggle

to mark and unmark.

 A Ctrl + single mouse left click selects all the indicators within a node.

 An Embedded Search or an Auto Search can be performed on the indicators in the list view.

Auto Search



The auto search feature searches for the string that you have typed, in the beginning of the indicator list.



The auto search feature compares your typing with the indicators available in the list of all entries starting

with the entered text or moves the cursor to the first indicator which matches the search string. This

matching is done sequentially from left to right on an alphabetically sorted list of indicators in the

database.



This utility is used in the List View of the Select Expression section of the Advanced option which is

available in the Select Indicators Window.



Embedded Search



The embedded search feature searches for the string you have typed in the whole indicator list and finds

the indicators that contain your search string. The search string here may not necessarily be in the

beginning of each indicator as in the auto search.







Example: To search for the word cement in the list of indicators, enter "cement" in the search box and

it will find all indicators which have the word "cement" in them.









Page 24

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Expression Based Query







The Expression based queries provide you with a powerful tool to generate user defined queries using the

logical operators like ,= = and mathematical operators like addition (+), multiplication (*), division (/)

and subtraction (-).



Depending on the indicators selected, you can specify the expression based query on the three fields -

Value (Val)Year-on-Year Growth (YoY) and Present-on-Preceding (PoP).





Example: To find out sugar production for a given period that is greater than 100,000 tonnes, select the

Sugar production indicator and specify ival>100 in the query expression.



Typically, in an expression-based selection system, the list of fields that can be used in the expression are

displayed in a separate window by clicking on Select Expression button. Fields can be directly inserted

into the expression by double clicking on the field.







Specify the date range to query on (Reference Date) and the date range for Output Date, if it is different

from the Reference Date.









Enter Reference Date:



This option allows input of the year(s) for which a query is to be executed. A list of valid inputs for this

option is given below.





Syntax Explanation





1999 199912





1999|2000 199912 OR 200012 (any)





199903 & 200012 Both true





(1998+1999+2000)>= True for any two or more of 199812,199912,200012

2









Page 25

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







L Latest for the indicator (per indicator basis)





L1 L





L2 LO2





LO2 Any of 2 latest records (per indicator basis)





LA2 All latest 2 records





LC3 >= 1 True for any one or more of latest 3 records (per indicator basis)





1999 & LC3>=1 True for 199912 and at least 1 or more records of latest 3 records









Enter Output Date:



This provides for input of the year(s) for which data is required. A list of valid inputs for this option is

given below.





Syntax Output Result





L One column - latest data

1999 One column 199912

199912 One column 199912

DEC1999 One column 199912

1999-2000 All data in the range between 199912 and 200012

199812 - All data of and after 199812

- 2001 All data of and before 200112

L3 The latest 3 records available. 3 column output L, L-2, L-3

ALL All data available in the database



Please Note:

 The logical operator "&" (AND) and "|" (OR) can be used in the reference years. Only "|" (OR) can

be used in the Output Date option.

 If both the fields are left blank, then by default the latest data will be shown in the output.

See Also: Expression & Unit Headers







Page 26

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Expression & Unit Headers







When using the expression based query, the program provides headers for each expression used.



You can change the default expression headers.



The usage of this facility is explained in the following example:

 If you intend running a query to find out sugar production for a given period that is greater than

100,000 tonnes, specify ival>100 in the query expression where the default header for the

computation is "ival ".

 You could change it to a header like "Weight > 100" which is more specific.







In order to change the header,



1. Click on Change Header/s button which will enable the header grid.



2. Click on the Expr Header column against the appropriate expression and give your own header.









Note: The header defined by you will be shown as "_U" followed by the given header name in the

Output Sheets, indicating that it is a user defined.









Page 27

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Arithmetic Operators and Functions







An expression is denoted by "expr". It can be a field or fields conjuncted with operators or functions.



The following is the list of operators available in Industry Analysis Service.



Symbol Usage Explanation

+ expr1 + expr2 Returns the sum of two fields

- expr1 - expr2 Returns the difference of two fields

* expr1 * expr2 Returns the product of two fields

/ expr1 / expr2 Returns the quotient of two fields

() (expr) Use of parenthesis

& (expr1) & (expr2) Uses the logical operand AND

| (expr1) | (expr2) Uses the logical operand OR

! !(expr) Implies NOT field

, expr1,expr2 Separates two expressions



More on comma(,)



The "," has a useful application in the Query option.



To list several fields or expressions in the display after a query is run, you may use the option

expr,expr,1 . The query is executed on the last expression, but all the fields (or expressions) are

displayed.



== expr==value or expr1==expr2 Returns True if the expression equals the value

or the second expression.

> expr > value or expr1 > expr2 Returns True if the expression is greater than

the value or the second expression.

= expr >= value or expr1 >= expr2 Returns True if the expression is equal to or

greater than the value or the second

expression.

expr value or expr1 expr2 Returns True if the expression is not equal

to the value or the second expression.

growth growth(expr1,expr2) Returns the growth in terms of percent

increase or decrease, as the case be) of

expression1 over expression2.

year year(yearfield) This function is used to convert the yrfld to the

form MMM YY.







Page 28

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





kdate kdate(datefield[,D/M/Y]) This function is used to convert the dtfld to the

form dd-MM-YY. The ordering of the date,

month and year components can be specified

in the argument.

ym ym(datefield) This function is used to convert the dtfld to the

form YYYYMM. It is used only in reports.









Page 29

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





CMIE Sets







CMIE Sets are created and maintained by CMIE.

 Click on the File-open option or open tool button in the Select Indicators Window to access CMIE

sets. On doing so, Industry Analysis Service displays a window titled "Run/Load Set(s)" with two

lists -- one of CMIE SETS and another of USER SETS.

 Industry Sets are organised in a multi tier Tree Structure. Move the cursor to the required set and

single click on the expand tree ("+" sign) to get a display of the first tier sets. Repeat the same step to

veiw the second tier sets under that group and so on.

 You can double click on any set displayed in the Run/Load Set(s) window to view the contents in a list

box. Use the "Esc" key or the "X" control on the title bar to close this contents viewer.

 Check mark one or more sets that you wish to use and then click on one of the execute buttons -

Load Sets or Run Sets.

 Load Sets will simply load the selected sets with the frequencies and expressions that were saved

with those indicators.

 Run Sets will execute the selected sets based on their saved frequencies and expressions and will

pick up the output date that is entered in the Select Indicators Window along with query expression

(if any). The output of each set will be displayed in a separate Output Sheet.









Page 30

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





User Sets







Creating / Saving



User Sets are created from contents of the Select Indicators Window.



To do this, click on tool button or select Save Set option from the File menu. A Save As dialog box

is displayed where your set will be saved in the user sets directory within the default working directory.



This will save the selected indicators, their marked frequencies and the selected expressions (not the

query expressions but the ones in the Select Indicators Window).



Viewing / Loading Contents



 Click on or select Run/Load Set option from the File menu. On doing so, the program displays

a window where the list of CMIE and User Sets is displayed.



 The User Sets section displays the list of User Sets created and saved.



 Check mark one or more sets that you wish to use and then click on one of the execute buttons -

Load Sets or Run Sets.



 Load Sets will simply load the selected sets with the frequencies and expressions that were saved

with those indicators.



 Run Sets will execute the selected sets based on their saved frequencies and expressions and will

pick up the output date that is entered in the Select Indicators window along with query expression

(if any). The output of each set will be displayed in a separate Output Sheet.









Page 31

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









Page 32

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Tools Available







File Options:



Run/Load Sets





To select this option click on the tool button.



 This displays a window where the list of CMIE and User Sets is displayed.



 The User Sets section displays the list of User Sets created and saved.



 Check mark one or more sets that you wish to use and then click on one of the execute buttons -

Load Sets or Run Sets.



 Load Sets will simply load the selected sets with the frequencies and expressions that were saved

with those indicators.



 Run Sets will execute the selected sets based on their saved frequencies and expressions and will

pick up the output date that is entered in the Select Indicators Window along with query

expression (if any).The output of each set will be displayed in a separate Output Sheet.



Save Set



To select this option click on the tool button.



 This displays a Save As dialog box where your set will be saved in the user sets directory with the

default working directory.



 This will save the selected indicators, their selected frequencies and the selected expressions (not the

query expressions but the ones in the Select Indicators Window).



Print Setup



To select this option click on the tool button.



The Print Setup option opens a dialog box where you can:



 Change the printer properties



 Select the paper size for printing



 Select source of the paper (tray) in the printer and



 Set the orientation of paper - whether you want Portrait/Landscape.



Print Report View









Page 33

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







To select this option click on the tool button.



This option will be enabled when the Report View mode is on. When selected, it sends the contents of

the Report View to your default printer.





Edit Options:



Paste





Pastes contents of clipboard. You can select this option by clicking on the tool button.



Clear All



Clears all selected indicators. You can select this option by clicking on the tool button.





View Options:



Settings





Allows you to change general program settings. You can select this option by clicking on the tool

button.





Click here for more on Settings.







Tools Options:



Recall



Recalls the indicators selected by you in the last run query. You can use this option by clicking on the

tool button.









Page 34

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Organisation of Query Window







The Query Window is organised into 3 data query modules which are..







 Select Indicators

 News by Category

 News by Text Search









Page 35

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Select Indicators







The Select Indicators Window is the basic aspect of Industry Analysis Service. It permits searches on

the database. With the query option, you can search for indicators which match the criteria that you may

set.



 The Select Indicators Window will be displayed when you click on tool button or select Select

Indicators option from the Launcher menu.

 The Execute Commands can be used to perform the search.

 Results of a query are displayed in the Output Sheets.







Organisation of the Select Indicators Window:



The Select Indicators Window consists of the following sections:



Industry Sectors



This section has a list of different industry sectors for quick access. A click on any of the sector names,

expands/collapses the tree item of the relevant sector in the List of Indicators section.



List of Indicators



This is a comprehensive tree structure displaying indicators for the industry sectors. An indicator can be

selected or unselected by a single mouse left click on the box next to the indicator name. To select or

unselect an entire level in the tree structure press and hold the Control key and click the left mouse

button once.



If a + sign is displayed before any indicator's selection box, it means that there are further levels of

indicators below the current indicator. To view the lower levels, click on the + sign. Then the + sign will

also change to - which can be clicked to close the level.



The Collapse All option in the right click menu in the indicators box can also be used to collapse the

entire tree structure right up to the 1st level.



Frequencies



This section provides the facility of selecting the frequencies for the required indicators required. The

types of frequencies available are:

 Annual

 Quarterly

 Cumulative

 Monthly

 Weekly

 Daily

Frequencies available for an indicator will be shown by a white empty box in this section. A single

mouse left click is a toggle to mark or unmark the frequency.







Page 36

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Note: At least one frequency has to be marked in order to run your query. You may mark more than

one frequency in any of your queries.

Expressions



This section provides the expression types for the indicators. There are three types of expression

provided:

 IVal - Indicator Value

 YoY - Year on Year Growth

 PoP - Present on Preceding Growth

The expression "IVal" is selected by default. Explicit selection can however be made of any one or more

of the three expressions listed above.



Selected Indicators

 This displays the list of indicators selected by you from the List of Indicators section.

 An indicator is displayed in the Selected Indicators section only if you mark at least one frequency for

that indicator.

 If you click on any indicator in this list, the tree in the List of Indicators section will open to the

indicator's level and highlight it.

 You can double click on any indicator in this list to remove it from the list. This also means unselecting

the indicator in the Indicators Tree along with the frequencies selected for it.

Advanced Options



Two advanced options are available in the Select Indicators Window:

 What's New

 Query







What's New:

 This option facilitates viewing of indicators which were updated on one or more date(s) or date

range(s).

 The list of update dates are displayed in the New Data Available section of the What's New dialog

box. Double click on the required date or enter it in the Enter Date Range section of the What's New

dialog box.

 Enter multiple dates by separating them with a comma ",".



Eg: 16/07/2001,17/07/2001,18/07/2001



 Enter date range by separating two dates by a hyphen "-".



Eg:16/07/2001-20/07/2001

 Mark the required frequencies to be searched and then click on the execute buttons: AND or OR.

 AND: This execute command searches for the updated data for the given date range and

frequencies from the selected indicators and keeps only those indicators which have been

updated.









Page 37

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 OR: This execute command searches for any indicator(s) which have updated data for the

entered date range and frequencies in the What's New dialog box.



Query:

 The expression and date conditions can be specified to apply to the selected indicators in the Query

option.

 Type in the expressions in the Enter Expression area or select from the available list which is

displayed by clicking on the Select Expression button.

 The headers can be changed by clicking on the Change Header/s button

 Give the appropriate date range for the query expression and click on OK.

 This will enable the query expression to be applied for the indicators. A green box next the Query

button indicates usage of the query in the Select Indicators window.

 To clear a query, click first on the Clear All button and then on OK. The Clear All tool button

and Edit menu option also clears the Advance Query option contents.

Select Output Format



Allows you to select the output format:

 (1) Ind x Dt - Information on each Indicator will be displayed row-wise.

 (2) Dt x Ind - Information on each Indicator will be displayed column-wise.

The default output format of your choice can be selected using the Settings option from the Tools menu

or the Settings tool button on the Tools toolbar.



Enter Output Date



This provides the year(s) for which data is required. An example of various entries for this are given

below:





Syntax Output Result



L One column - latest data

1999 One column 1999

199912 One column 1999

DEC1999 One column 1999

1999-2000 2 columns

199812 - From 199812 till available

data

- 2001 From available data till

200112

L3 Any of latest 3 records

from database. 3 column

output L, L-2, L-3

ALL All data for the selected

Indicators and frequencies









Page 38

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Select Date Interval

The Date Interval is a tool that assits you in specifying multiple dates across a date range, where

the interval between each data point is specified by the user. For example, if you want to generate all

Cumulative frequency data of Cement Production in the month of June for all years between 1995 and

2003, normally you would type in the years as 199506,199606, 199706.. .



With the help of the Date Interval feature you can now just type in the range like 199506-200306 and

select the Annual option from the Date Interval drop down to get all June Cumulative numbers. You just

need to select the Cement Production Indicator and Cumulative frequency and generate the data.





Execute Commands









The selection is to be articulated by you in terms of selecting the indicators through Structured Selection

process and selecting the required frequencies and expressions. After the selection is specified in the

above manner click on the any of the execute buttons to run the query.



Note: For running the query first time, you have to use the OR Execute Button.



On doing so a window will pop up to indicate the progress in executing the query.



A query can be aborted midway by clicking on the cancel button.



On completion of a query, the results are provided in the Output Sheets . The indicators selected up to

the last execution of the query are displayed in the Output Sheets, along with the values of expressions on

which the query was performed. Information provided in the Output Sheets can also be further

processed.









Page 39

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





News by Category







This is a structured search by sector which will yield news abstracts on all the important developments in

the sector selected. This particular search feature also allows you to view articles which are related to

one or more industry sectors using logical operands.









The basic layout of this search feature is as follows:



Click on tool button or select News by Categorywise option from the Query drop down

toolutton.







Indicators



This is the complete list of all industry sectors. Double click on the Industry to select it. It will then be

displayed in the Selected Category/s section.



Selected Category/s



The selected indicators are displayed in this section. Here you have the option to give conditions for

performing search, using the following arithmetic operators:



 ( : Open parenthesis









Page 40

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 ) : Close parenthesis



 & : Uses the logical operator AND



 | : Uses the logical operator OR



 ! : Implies NOT that particular indicator



Enter Text to search in the above Category



This search facility is available for the above mentioned categories.



Enter the text string to search for in the text box and click on Search button.



For example: To search for Polymers in the list of Indicators, enter 'polymers' in the text box and click

on Search button. As a result, the cursor will be placed on subject with the text string 'polymers'

anywhere in its name.



Date Range



Allows you to enter a desired date(s) or a date-range(s) for the article search. "L" indicates latest

available article.



Search for Indicators in the Current Indicator Sheet

Check mark against this option to search for new articles on indicators in current Indicator Output

Sheet.

Execute Commands



OR



Click on this button to add the results of this query to the current output sheet in the Output Sheets

Window.



NEW



Click on this button to add the results of this query to the current output sheet in the Output Sheets

Window. This sheet will then be marked as the current output sheet.



REPLACE



Click on this button to replace the contents of the current output sheet in the Output Sheets Window,

with the results of this query.



AND



Click on this button to keep articles in the current output sheet which match the results of this query.



ADD-COL



Click on this button to add the selected information to the current output sheet for articles which match

the given criteria without removing any article from the sheet.







Page 41

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





NOT



Click on this button to remove from the current active sheet, all indicators whose name appears in the

results of this query.

While the query is running, the progress of the query is displayed in the progress box. To stop the query

midway, click on the Stop button and the output till that point is displayed. Click on the Abort button if

you want to cancel the query. These two buttons will not respond if the query is already over and the

results are being formatted for display in the output sheets.

The result of the query is then displayed in the News Output Sheet Window.









Page 42

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





News by Text Search







News articles on any particular Indicator can be searched by performing a text (word) query on the

contents of the articles.









To use this query, do the following:



 Click on tool button or select News by Text Search option from the Query drop down

toolbutton.

 Enter a text string in 'Enter word for auto search' text box. The auto search feature searches for the

string that you have typed in the database. The search is limited only to a single word entry.

For Example : To search for news articles on steel.

 Enter the text string 'steel' in the auto search text box.

 The results of word auto search will be displayed in 'Matching words found in Articles' section.

Double-click on the required word to insert it in the 'Enter word string to search in news article'.

 To make the search process more specific use the arithmetic operators.

The different operators available for the search are:

 ( : Open parenthesis

 ) : Close parenthesis

 or : Uses the logical operator OR







Page 43

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 and : Uses the logical operator AND

 not : Implies NOT that particular word/string

 near : Specifies the proximity/gap between two or more words in a sentence. The proximity level

can be selected from the list box provided below the operator buttons.

For Example: "steel + automobile" along with a proximity of 4 will search for articles where the

words steel and automobile are within 4 words of each other.

 para : gives the conditions that word1 and word2 have to be in a single paragraph in the news

article.

For Example: "cement - madhya - pradesh" will search for news articles where all the three words

appear in a single paragraph.

 Enter the date range in 'Enter Date Range to search for' section.

 To search for news articles on indicators in current Indicator Output sheet check mark against Search

for Indicators in current Indicator Sheet.

 To execute the query, select any one of the six Execute Commands buttons displayed in the bottom

right hand side of the Query display area.

OR



Click on this button to add the results of this query to the current output sheet in the Output Sheets

Window.



NEW



Click on this button to add the results of this query to a new output sheet in the Output Sheets

Window. This sheet will then be marked as the current output sheet.



REPLACE



Click on this button to replace the contents of the current output sheet in the Output Sheets Window,

with the results of this query.



AND



Click on this button to keep news articles in the current output sheet which match the results of this

query.



ADD-COL



Click on this button to add the selected information to the current output sheet for news articles which

match the given criteria without removing any news articles from the sheet.



NOT



Click on this button to remove from the current active sheet, all indicators whose name appears in the

results of this query.



While the query is running, the progress of the query is displayed in the progress box. To stop the query

midway, click on the Stop button and the output till that point is displayed. Click on the Abort button if







Page 44

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





you want to cancel the query. These two buttons will not respond if the query is already over and the

results are being formatted for display in the output sheets.



The result of the query is then displayed in the News Output Sheet Window.









Page 45

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Chart Viewer







The Charting utility is a powerful tool for graphical representation of the data in Industry Analysis

Service. There are three ways in which data is sourced for creating the charts:

 Output Sheets

 Analysis Worksheet

 Chart Templates









Page 46

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Output Sheets





 To use the option do the following :-

 Mark the data range to be plotted from an Output Sheet.

The data range selected should be a continuous range of cells and not two different ranges. If two

different ranges are selected then the last range selected will be plotted.



 Click on toolbutton or select Charts option in the Launcher menu.

 As a result, a Charts Viewer will be displayed. By default, the data will plotted as Line chart.

 You may change the chart type by selecting the desired type from the Chart drop down list.

 Checkmark against the Date Time in X-axis checkbox to view the precise date on the X-axis for

the data plotted.







You may also create charts based on CMIE templates or create User templates. Click here to know

more.









Page 47

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Analysis Worksheet





 Mark the data range/s to be plotted from the Analysis Worksheet.

The data range selected should be a continuous range of cells and not two different ranges. If two

different ranges are selected then the last range selected will be plotted.



 Click on toolbutton or select Charts option in the Launcher menu.

 As a result, a Charts Viewer will be displayed. By default, the data will plotted as Line chart.

 You may change the chart type by selecting the desired type from the Chart drop down list.

 Checkmark against the Date Time in X-axis checkbox to view the precise date on the X-axis for the

data plotted.









Page 48

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Chart Templates







Charts can be created from CMIE templates and User templates







To create charts based on templates do the following:

 Select the desired indicators by clicking on them in the Output sheet or in the Select Indicators

Structured List.

 Click on toolbutton or select Charts option in the Launcher menu.

 Checkmark against the Database Source Entities in the Chart Viewer. The indicators selected in the

Output Sheet will now be displayed in the section below the checkbox.

 Select the indicators in the above mentioned section and select the desired template in the Select

Template section. As a result, chart based on the indicators specified in the template will be created in

the right hand side section.

 By default, the chart will be plotted for latest 50 records. You may entire the required number of

records in the Days/Date Range text box. Checkmark against Freeze date to apply the changed

number of records across the other templates.

 You may select the required frequency from the Frequency drop down list. By default, Annual

Frequency is selected. Checkmark against Freeze frequency to apply the changed frequency across

the other templates.

 Plot name & Parameters box will display the function name which is used to plot the chart. The

parameters used for the function can be changed by entering the required values in the corresponding

text boxes.

 Click on the Refresh button to view the changes made.









Page 49

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





CMIE Templates







CMIE Templates are consist of indicators and parameters to plot a chart.



Following are the chart templates available in Industry Analysis Service :

 Simple Plot

 Exponential Plot

 YOY Growth (% chg)

 Relative Performance

 Internal Plot

 Trendlines

 Simple Moving Average

 Weighted Moving Average

 Exponential Moving Average









Page 50

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Simple Plot





 Chart Type: Line Chart

 Number of Entities displayed at a time: One.

 Time Range: Latest 50 records.

 Frequency: Annual

 Vectors: Value









Page 51

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Exponential Plot





 Chart Type: Line Chart

 Number of Entities displayed at a time: One.

 Time Range: Latest 50 records

 Frequency: Annual

 Vectors: One

 log of value









Page 52

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





YOY Growth (% chg)





 Chart Type: Line Chart

 Number of Entities displayed at a time: One.

 Time Range: Latest 50 records.

 Frequency: Annual

 Vectors: Year on year growth









Page 53

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Relative Performance





 Chart Type: Line Chart

 Number of Entities: Upto a maximum of 10.

 Time Range: 1950 - 2002.

 Frequency: Daily

 The beginning point of all vectors (selected indicators values) is set to 100. All subsequent values (vi

)are computed as follows. vi = (pi/(p(i-1)), where p is the value.









Page 54

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Internal Plot





 Chart Type: Line Chart

 Number of Entities: Single.

 Time Range: 1950 - 2002.

 Frequency: Annual

 Interval: 12

The object of this chart is to show a comparative chart with each series being shown as a 12

points series. The entire date range is split up into intervals of 12 points each. If you select Monthly as

your frequency then the chart intervals will be 12 month or yearly intervals.









Page 55

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Trendlines





 Chart Type: One Chart Line type

 Number of Entities displayed at a time: One

 Time Range: Latest 50 records.

 Frequency: Annual

 Vectors : One

 Value

 Trendlines are plotted on the price line using the default trendlines indicator of Teechart.









Page 56

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Simple Moving Average





 Chart Type: Line Chart

 Number of Entities displayed at a time: One.

 Time Range: Latest 50 records.

 Frequency: Annual

 Vectors: Three

 Value, pi

 7-day simple moving average, ps7 = Avg of current and preceding 7 days values.

 30-day simple moving average ps30 = Avg of current and preceding 30 days values.









Page 57

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Weighted Moving Average





 Chart Type: Line Chart

 Number of Entities displayed at a time: One.

 Time Range: Latest 50 records.

 Frequency: Annual

 Weighted moving averages assign higher weights to recent periods. Weights decline linearly as time

recedes.

 Vectors: Three

1. Value, p i

2. 7-day weighted moving average, p w7 = See formula for n days below.

3. 30-day weighted moving average pw30 = See formula for n days below.



Weighted moving average over n days =

(pt.n + p(t-1).(n-1) + p(t-2).(n-2) + & + p(t-(n-1)).(n-(n-1)) ) / (n + (n-1) + & + (n-(n-1))

where pt is today's value

 7 and 30 should be shown as default values of parameters.









Page 58

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Exponential Moving Average





 Chart Type: Line Chart

 Number of Entities displayed at a time: One

 Time Range: Latest 50 records.

 Frequency: Annual

 Vectors: Three

 Value, pi

 7-day exponential moving average, pe7 = See formula for n days below.

 30-day exponential moving average pe30 = See formula for n days below.

 The exponential moving average over n days is computed as follows:



First, we determine the value of the exponential factor (e).

The value of n determines e.

If n = 20, e is 0.05



The first (earliest) exponential moving average (ema) value is the simple moving average over

the preceding n days. The following ema values are estimated as follows.



ema = prev(ema) + e*(price - prev(ema))

 7 and 30 should be shown as default values of parameters.









Page 59

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





User Templates







You may create User templates to plot charts.



Creating User Templates.

 Checkmark against Database Source Entities. Select anyone of the templates in Select Template

section.

 Click on Edit Template button. As a result, a Edit Template dialog box will be displayed.









 You may want to plot single or multiple indicators in one chart. Accordingly, select the required option

from the Number of Entities drop down list.

 Enter the number of days or date range in the Date Range text box. By default, L50 (i.e) latest 50

records will be selected.

 Annual frequency will be selected by default.

 Data Indicator section

 Click on Select Indicator text box, as a result Select Expression dialog box will be

displayed. Double click on any of the required expression, which will then be displayed in

the Select Indicator section.

 You may select the chart type from the Plot Type drop down list.

 Enter the required chart title in the Plot Title text box.

 You may select the plot position from Plot Position drop down list. The available positions

are: Upper and Lower.

 To add another indicator to plot, click on Add new Indicator button.







Page 60

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 To delete a particular indicator, select the row and click on Delete Selected Indicator

button.

 Function Indicator section

 Click on Select Indicators text box, as a result function drop down list will be displayed.

Select any of the required function, which will then be displayed in the Select Indicator

section.

 You may select the chart type from the Plot Type drop down list.

 Enter the required chart title in the Plot Title text box.

 You may select the plot position from Plot Position drop down list. The available positions

are: Upper and Lower.

 Select the number of indicators from the Data Source drop down list.

 You may specify different parameters of a function in Day1, Day2 and Extra textbox.

 To add another function, click on Add new Function button.

 To delete a particular function, select the row and click on Delete Selected Function button.

 To save the template, click on Save button. A Save As dialog box is displayed showing the

default directory where you can save your template. The default directory is Usercht. Enter the

required file name and click on Save button.

 The User template name will be included in Select Template section.









Page 61

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





File Options







Import from Output Sheet



Select the Import from Output Sheet option in the File menu to import a chart exiting in an Output Sheet

to the Chart Viewer.

Export To Output Sheet

Select the Export to Output Sheet option in the File menu to export a chart created in the Chart Viewer

to an Output Sheet. To view more than one chart in one Output Sheet, select the Output Sheet Per

Page option in the View Menu in the Output Sheet and select the Export to Output Sheet option.

Print



Printing of the current chart can be done by selecting Print Option in File menu.



This will directly send all the page(s) in the active document to the printer and print a single copy of the

active document.



Print Preview



The Print Preview option for Charts allows you to specify margins, paper orientation, the level of detail,

and print settings. The changes are displayed immediately in the print view window. The page margin

lines, when visible in the View area can be moved directly by the single click and drag mouse action.









Page 62

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Edit Options







Delete Lines



To delete line that you may have created as pointers in your charts select the Delete Lines option in the

Edit menu.

Clear Database Entities

Clear Database Entities option in the Edit menu will clear the entities that you have selected as database

source.

Right Click Actions

To activate the right click actions select the Right Click Actions option in the Edit menu.

Properties



There are 2 principal sections to the Chart Properties, Chart parameters and the Series parameters,

which are separated as 2 tabs of the Chart Properties.



 Chart



You may add a mixture of different Series types to the Chart to define the specific Chart of your choice.



 Format Page



Contains Series type specific parameters.



 General Page



Series value format, Axis association.



 Marks Page



Series Mark format, text, frame and back colour and positioning.



 Data Source Page



Access to Function definition and ODBC data sourcing



 Series



 Series page



Series pages will contain parameters dependant on the series type concerned. The Combo box at the

top of the Series tab page shows which series you are editing.



Note here that you are not limited to predefined Chart types. Most Series types are compatible with

other Series types on the same Chart. Those Series types not available are greyed out.



To add a new Series to a Chart select the Add button on this page which will display the Chart Gallery.









Page 63

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Select the Series type of choice from the gallery and it will display on the Series page of the Chart

Editor.



 General Page



Margins, Zoom and Scroll, Print Preview and Export.



 Axis Page



All Axes definition. Some parameters depend upon the Series associated with the axis.



For example, Date time depends on whether the Series data has date time definition, this can be

configured on the Series 'General' page of the Series concerned.



 Titles Page



Chart Header and Footer.



 Legend Page



Legend display. Formatted displays work in conjunction with the Chart Series. See also the 'General'

page of the Series.



 Panel Page



Chart Panel display properties. Colours, Bevels, Back images, Colour Gradient and Border.



 Paging Page



Definition of number of points per chart page. May be used to browse at design time, too, if your data is

sourced from an ODBC data source.



 Walls Page



Left, Bottom and Backwall size and Colour definitions.



 3D Page



Enable/disable and modify 3D display parameters.









Page 64

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





View Options







Pages



Select Pages option in the View menu to to view the created chart in multiple pages.

Legend

To change the position of chart legend select Legend option in the View menu.









Page 65

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





PDF Documents







The monthly document released under the Industry Analysis Service, named as "Indian Industry: A

Monthly Review" is available in the PDF format for easy viewing and navigation. The entire document as

well as individual Industry Sectors are available as separate PDF files.









The search and access to the PDF documents is available thru two options, the PDF query and the

Document Viewer . These options are also accessible via the Launcher Menu.









Page 66

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





PDF Query





 Click on tool button or select the PDF Query option from the Launcher menu. This will display a

window which gives you tools to select required documents.

 In the Select Industry Sector(s) section, click on one or more sector names for which you wish to view

the documents.

 The Select from available dates section gives a list of the publication issues that may contain your

required documents.

 IAS provides you with a document which gives basic information of all the sectors. To access this

document, select Entire from the list of sector names and select Basic Facts in the Type section.

 You can perform a word search within the available documents. To do this, unselect any sectors if

selected. Type in the keywords and click on the Find Documents button.

 Having selected the issues dates, click on the Find button. This will list out all the documents pertaining

to the selected sectors within the given date range, in the Found Documents section.

 You may double click on the document name in the Found Documents section or click on the

Document Viewer toolbutton to view the document/s in PDF format.

 This will launch the Document Viewer in Acrobat Reader®.









Page 67

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Document Viewer







Document Viewer enables you to view documents selected in the PDF query.



 Click on the toolbutton to access the Document Viewer. If the Document viewer is accessed

without any selections in the PDF query, then the Basic Facts document is loaded.

 Click on the Bookmark tab, to view the list of selected documents. You may then click on

the required document name to view the document. This list of selection can also be viewed by

clicking on the Document menu.

 Also, Prev and Next buttons are available for browsing through the viewed documents.







Viewing tables in PDF files as Microsoft Excel® files :



Tables available in the PDF documents can be viewed as Microsoft Excel® files.

 When you move your mouse cursor over the table in the PDF document, the mouse cursor changes to

a hand symbol.

 Click on the table with this hand symbol. The data in the table will be exported to an Excel®

spreadsheet.









Page 68

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Output Sheets







The results of all query executions, news articles search and Chart creations are displayed in this

window. The Output Sheets window can hold multiple sheets each displayed in a separate tab. Each

sheet is accessible by clicking on its tab which displays the sheet name.



There are three types of output sheets displayed in this window,



Indicator Data



News Outputs



Chart Outputs









The Output Sheet Status can be changed by using the drop down tool button. You can also rename

the Sheet by using the tool button.









Page 69

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Indicator Data







The indicator data sheet gives the list of indicators based on your query.



The following options makes it easy to navigate through the data in this Output Sheet:

 File Options

 Edit Options

 View Options

 Tools

 Right Click Menu









Page 70

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





File Options







Explained here are the different options that are available in this section.







Open



When you click on the Open toolbutton, a dialog box is displayed showing the default directory

where it expects your files to be. This default directory is the working/ start in directory as specified in

the program shortcut properties. Select a file with a single click, from the available list and click on the

Open button.

To open a file from a different location do the following:

 In the Look in box, click the drive or folder that contains the file.



 In the folder list, double-click folders until you open the folder that contains the file you want.



 Double-click the file you want to open.



Save

When you click on the Save toolbutton, a dialog box is displayed showing the default directory

where you can save your file. This default directory is the working/ start in directory as specified in the

program shortcut properties.

The Save dialog box opens only when a file is saved for the first time. When you click on the Save

toolbutton again for the same file in the same session, the file will get saved automatically without asking

for any confirmation, file name or location. To save a copy of the file with a different file name or

location, use the Save As option.

To save a file in a different folder while using the Save option, do the following:

 Select the appropriate drive from the "Save in" box, or double-click a different folder in the folder

list.



 To save the file in a new folder, click Create New Folder.



 In the File name box, type a name for the file.



 Click on the Save button.



Save As



The Save As has the same functionality as the Save option except that it allows you to save a copy

of a file with a different file name.

To save a file using the Save As option, do the following:

 Select the appropriate drive from the "Save in" box, or double-click a different folder in the folder

list.



 To save the file in a new folder, click Create New Folder.









Page 71

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 In the File name box, type a name for the file.



 Click on the Save button.



Save As Excel file

The Save As Excel file option allows you to save the current Output Sheet as Microsoft Excel file

(.xls). For this Microsoft Excel is required to be installed on the Computer which is being used for

accessing Industry Analysis Service.

To save an output sheet as an Excel file:

 Select Save As Excel file from File Menu or click on Save As Excel file tool button.



 To save the file in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list.



 To save the file in a new folder, click Create New Folder.



 In the File name box, type a name for the file.



 Select the Entire (entire worksheet) or Selection (selected cells) option, displayed at the bottom of

the "Save As Excel file" box, as per your requirement.



 Click on the Save button.



Save As Text file

The Save as Text file option allows you to save the contents of an output sheet as a Text file (.txt).

To save the contents of an output sheet to a Text file:

 Select Save as Text file from File Menu or click on Save as Text file tool button.



 To save the file in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list



 To save the file in a new folder, click Create New Folder



 In the File name box, type a name for the file.



 Select the Tab Delimited or Pipe Delimited option, displayed at the bottom of the "Save as Text file"

box, as per your requirement.



 Click on the Save button.



Set Print Area



Sets the selected cells as the area to be printed. Follow the steps given below for using this option.



 Mark the desired cells to be printed.



 Click on the toolbutton or select the Set Print Area option from the File menu.



 Only the selected cells will be printed when you give the print command.









Page 72

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Clear Print Area

Clears the print area setting. Click on the toolbutton to clear the print area, set previously for the

current sheet using the Set Print Area option.

Note: This will be disabled unless you have set up a print area using the Set Print Area option

Page Setup

The Page Setup option gives a dialog box where you can:

 Set the left, right, top and bottom margins for the page.



 Select centering of data on the page.



 This can be done by marking or unmarking the check boxes labeled-Vertical and Horizontal. Vertical

will center the data vertically on the page. Horizontal will center the data horizontally on the page.



The following properties can be marked or unmarked as per your requirements:



 Row Header: Displays the row header as 1,2,3,4...etc



 Column Header: Displays the column header as A, B,C, D,E...etc



 Horizontal Lines: Displays horizontal grid lines



 Vertical Lines: Displays vertical grid lines



 Print Frame: Prints the grid border



 Only Black and White: Sets the document printing in black and white mode.



 Print Preview: Allows you to preview the page to be printed based on your page setup selections.



Print Setup



The Print Setup option allows you to change the following Print Settings:



 Printer properties



 Paper size



 Source of the paper (tray) in the printer and



 Orientation of paper - whether you want Portrait/ Landscape.



Print Preview



This feature allows you to preview the current Output Sheet as it would be printed with the current Print

Settings.



 Click on the Print Preview toolbutton to navigate through all your desired pages to be printed, by

using the Next Page and Prev Page buttons.



 The Two Page option allows you to preview two pages on the screen simultaneously. While in Two







Page 73

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Page mode, the button shows you the toggle option to revert back to the One Page mode.



 Zoom In and Zoom Out buttons allow you to magnify and reduce the size of the preview respectively.





 The Close button is used to exit from the Print Preview mode.



 Click on Print to send the sheet being viewed for printing.



Print



Printing of the current Output Sheet can be done using one of the following two options:



 Click on the Print Direct toolbutton on the toolbar:



This will directly send all the page(s) in the active document to the printer and print a single copy of the

active document.



 Select the print option from the file menu:

This will display the Print dialog box where you can:

Specify the range of pages to be printed.

Specify the number of copies to be printed.

Change Printer properties by clicking on the Properties button.









Page 74

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Edit Options







Explained here are the various options that are available in this section.







Copy



To copy the contents of a cell or a cell range to the Analysis Worksheet or another spreadsheet:



 Click on the source cell or mark the cell range.



 Click on the toolbutton or select the Copy option from the Right Click menu or from the Edit

menu.



 Use the Paste option in Analysis Worksheet or an external spreadsheet to paste the contents to that

location.



Delete Rows

 To delete row(s) use the Delete row(s) option.



Select the row to be deleted.



 Click on toolbutton or select the Delete Row(s) option from the Edit menu.



Delete Columns



To delete column(s) use the Delete Column(s) option.



 Select the column to be deleted.



 Click on or select the Delete Column(s) option from the Edit menu.



Delete Current Sheet



To delete an output sheet:



 Select the output sheet by clicking on it's tab to bring it on top.



 Click on the Delete Current Sheet toolbutton or select the Delete Current Sheet option from the

Edit Menu









Page 75

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





View Options







Explained here are the various options that are available in this section.



Normal View



This option zooms the current Output Sheet to normal view (100%). Click on the toolbutton or

select the Normal View option can be selected from the View menu.

Zoom In

To increase the view size of the current Output Sheet, click on the Zoom In toolbutton or select the

Zoom In option from the View menu. By default, the view size will be enlarged by 125% of the current

view.

Zoom Out

To decrease the view size of the current Output Sheet click on Zoom Out toolbutton or select the

Zoom Out option from the View menu. By default, the view size will be decreased by 75% of the

current view.

Find



To search for a character or numerical string in the current Output Sheet, use the Find option.



 Click on the Find toolbutton or select the Find option from the View menu.



 On doing so, a dialog box will be displayed.



 In the Find What text box, type the string required to be searched.



 If the search string exists in the file then, the cursor will be placed there highlighting the search string.



 If the search string does not exist in the file, a "Cannot find xyz" message will be displayed, where xyz

is the entered search string.



Settings

To customize the program settings, click on Settings toolbutton or select the Settings option from

the View menu.

Click here for more on Settings









Page 76

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Tools







Explained here are the various options that are available in this section.



Sort Rows



This option includes:



 Ascending



This sorts the rows by the selected column in ascending order. Select the Ascending option from the

Sort Rows toolbutton, Right Click menu or from Tools menu.



 Descending



This sorts the rows by the selected column in descending order. Select the Descending option from

the Sort Rows toolbutton, Right Click menu or from Tools menu.



 Multiple



This option sorts the rows by more than one column at a time.



 Select the Ascending option from the Sort Rows toolbutton, Right Click menu or from

Tools menu.



 On doing so, a dialog box will be displayed. Select the columns from the left section on which

you want to perform the row sorting.



 On selecting the required column headers, you may shift the position of the column headers in

the right section (Selected Headers section) by using the drag and drop feature.



 You can toggle between ascending and descending option next to the column header in the

Selected Headers section.



 Click on Sort button to perform the required sorting.



Sort Columns



This option includes:



 Ascending



This sorts the columns by a selected row in an ascending order. Select the Ascending option from the

Sort Columns toolbutton, Right Click menu or from Tools menu.





 Descending







Page 77

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









This sorts the columns by a selected row in a descending order. Select the Descending option from

the Sort Columns toolbutton, Right Click menu or from Tools menu.



 Multiple



This option sorts the columns by more than one row at a time.



 Select the Multiple option from the Sort Columns toolbutton, Right Click menu or from Tools

menu.



 On doing so, a dialog box will be displayed. Select the rows from the left section on which you

want to perform the column sorting.



 On selecting the required row headers, you may shift the position of the row headers in the right

section (Selected Headers section) by using the drag and drop feature.



 You can toggle between ascending and descending option next to the row header in the Selected

Headers section.



 Click on Sort button to perform the required sorting.



Output Sheet Status



All results of the queries run by you will be merged with, added to or removed from the Current

Indicator Sheet or a blank one if there is no such sheet available in the Output Sheets Window. The tab

of each sheet displays a star, whose colour indicates where a sheet is in Active, Blank or Force status.

Though several sheets can be marked as having a blank status, only one sheet can be marked as

Current and only one sheet can have the Force status.



Output Sheet Status : Explained below are the implications of the three states that an Output Sheet

can have:



Blank

Retains the contents of the current sheet and puts the output of the next query to a new sheet.



Current

Displays the output of the next query in the current sheet.



Force

Displays the output of the next query in the Force sheet. This can be explained with the help of the

following example:



Consider you have two sheets - Sheet1 and Sheet2 of which Sheet2 is in current state and Sheet1 is in

blank state. If you want to retain the data of Sheet2 and work on Sheet1 for your next query, make

Sheet1 as current. This makes the state of Sheet2 blank. After having performed the work on Sheet1

(which is in current state), you delete the sheet. This leaves Sheet2 in blank state. Now if you want to

work on the data in Sheet2, the query will not be able to work with that data since the sheet is in blank

state.









Page 78

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









So, when you want to work with data in Sheet1, change it to forced state instead of current state. This

will ensure that Sheet2 gets a current state after Sheet1 is deleted.









Page 79

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Right Click Menu







Some of the most commonly used tools are available in the Right Click menu.





 Place the cursor on the required cell.

 Click the right mouse button.

 This will display the list of tools available in the Right Click menu.





Following is the list of tools available in the Right Click menu:

 Copy

 Clear All

 Delete Row(s)

 Delete Column(s)

 Row Sorting

 Column Sorting

 Create Notes

 Related News









Page 80

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





News Outputs







The news articles obtained on performing the Categorywise Search and the Text Search are displayed in

News Output Sheet.



The News display consists of two sections:

 Header:This gives a list of all the articles found, based on the search criteria. Click on one/more

header to view the contents of those articles.

 Article content: Contents of news articles are displayed in this section.







The desired news articles can be searched using the following two options:



Categorywise



Text Search









Page 81

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









Page 82

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





File Options







Explained here are the different options that are available in this section.









Open



When you click on Open, a dialog box is displayed which takes you to the default directory where it

expects your files to be. This default directory is the working/start in directory as specified in the

program shortcut properties. To open a file in some other local/network location, select the appropriate

path.



To open a document on your hard disk or on the network:



 Select Open from File Menu or click on Open tool button.



 In the Look in box, click the drive or folder that contains the document.



 In the folder list, double-click folders until you open the folder that contains the document you want.



 Double-click the document you want to open.



Save



When you click on Save, a dialog box is displayed which takes you to the default directory where you

can save your file. This default directory is the working/start in directory as specified in the program

shortcut properties.



Save dialog box opens only once for a particular file when it is saved for the first time. To save a copy

of the file with a new file name, select the Save As option.



If you would like to share your file with others then save your file on the network.



To save a new, unnamed document:



 Select Save from File Menu or click on Save tool button.



 To save the document in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list.



To save the document in a new folder, click Create New Folder.



 In the File name box, type a name for the document.



 Click Save.



Save As







Page 83

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





The Save As option has the same functionality as the Save option except that it allows one file to be

saved as multiple copies with unique file names.



If you would like to share your file with others then save your file on the network.



To save a copy of a document:



 Select Save As from File Menu or click on Save As tool button.



 In the File name box, type a new name for the document.



 Click Save.







Note: To save the copy in a different folder, click a different drive in the Save in box, or click a different

folder name in the folder list, or both. To save the copy in a new folder, click Create New Folder.



Save As Word



The Save As Word option allows you to save the data from Output Sheets and Analysis Worksheet as

Microsoft® Word files (.doc).



If you would like to share your file with others then save your file on the network.



To save a document as Word file:



 Select Save As Word from File Menu or click on Save As Word tool button.



 To save the document in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list.



To save the document in a new folder, click Create New Folder.



 In the File name box, type a name for the document.



 Select entire file or selection at the bottom of the box as per your requirement



 Click Save.



Save As Text



The Save As Text option allows you to save the data from Output Sheets and Analysis Worksheet as

Text files (.txt).



If you would like to share your file with others then save your file on the network.



Save a document as Text file:



 Select Save As Text from File Menu or click on Save As Text tool button.







Page 84

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 To save the document in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list.



To save the document in a new folder, click Create New Folder



 In the File name box, type a name for the document.



 Select Tab Delimited or Pipe Delimited at the bottom of the box as per your requirement



 Click Save.



Set Print Area



Sets the selected cells to print area.



Page Setup



The Page Setup option gives a dialog box where you can:



 Set the left, right, top and bottom margins for the page.



 Select centering of data on the page.



 This can be done by marking or unmarking the check boxes labeled - Vertical and Horizontal



Vertical will center the data vertically on the page.



Horizontal will center the data horizontally on the page.







The following properties can be marked or unmarked as per your requirements:



 Row Header: Displays the row header as 1,2,3,4...etc



 Column Header: Displays the column header as A,B,C,D,E...etc



 Horizontal Lines: Displays horizontal grid lines



 Vertical Lines: Displays vertical grid lines



 Print Frame: Prints the grid border



 Only Black and White: Sets the document printing in black and white mode.



 Print Preview: Allows you to preview the page to be printed based on your page setup selections.



Print Setup



The Print Setup option gives you a dialog box where you can:









Page 85

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 Change the printer properties



 Select the paper size for printing



 Select source of the paper (tray) in the printer and



 Set the orientation of paper - whether you want Portrait/Landscape.



Print Preview

 Allows you to preview the page to be printed.



 In this mode, you can navigate through all your desired pages to be printed by using the Next Page

and Prev Page buttons.



 Two Page is a toggle mode that allows you to preview two pages at a time. While in two page mode,

the button shows you the toggle option to revert back to one page mode.



 Zoom In and Zoom Out buttons allow you to magnify and reduce the size of the preview

respectively.



 Close brings you out of the print preview mode.



 Print button takes you to the print dialog box where you can primarily specify the range of pages and

the number of copies to be printed.



Printing



Printing can be done in two ways:







1. By clicking on the Print Direct button on the toolbar:



 This will directly send all the page(s) in the active document to the printer and print a single

copy of the active document.







2. Selecting the print option from the file menu:



This will display a dialog box where you can:



 Specify the range of pages to be printed.



 The number of copies to be printed.



 Change of printer properties can also be done through this dialog box by clicking on the

Properties button next to your printer name.









Page 86

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Edit Options







Explained here are the different options that are available in this section.









Copy



Copies the selection to clipboard.

Clear All

Clears all contents.

Delete Row(s)

Deletes the selected row(s).

Delete Output Sheet

Deletes the current Output Sheet.

Output Sheet Status:Click here for more on Output Sheet Status.









Page 87

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





View Options







Explained here are the different options that are available in this section.









Show All



Displays all the notes in a contiguous manner for your reference.



Normal View

Zooms the current sheet to normal view (100%).

Zoom In

Zooms the current sheet to 125 % of the current view.

Zoom Out

Zooms the current sheet to 75 % of the current view.

Find



This option opens up a dialog box where you can type for a search string or a number you are

looking for in the Worksheet.



 In the Find What text box, type the string you want to search for.



 If your search string exists in the document then, the cursor will be placed there highlighting the search

string.



 If the search string does not exist in the document, a "Cannot find xyz" message will be displayed

where xyz is the search string entered by you.



Settings



Allows you to change general program settings.



Click here for more on settings.









Page 88

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Chart Outputs







Charts plotted in Industry Analysis Service are displayed in the Output Sheets Window. You can

either plot new Charts or add an additional series to existing Chart in the Output Sheets Window.



Use the Settings Option to specify the default Chart properties like, Chart

Type, Data Series and Back Colour.



Tools Available :



File Options:



Save



 Select Save from File Menu or click on the Save toolbutton.



 A dialog box is displayed with options to save the chart image as:



 Bitmap (*.bmp)



 Metafile (*.wmf)



 Enhanced Metafile (*.emf)



 Jpeg Image (*.jpg)



 After selecting the required file format, you can save the chart to a file or copy it to the

clipboard



Save As

The Save As option has the same functionality as the Save option except that it allows one file to be

saved as multiple copies with unique file names.

Print Setup



The Print Setup option gives you a dialog box where you can:





 Change the printer properties



 Select the paper size for printing



 Select source of the paper (tray) in the printer and



 Set the orientation of paper - whether you want Portrait/ Landscape.



Print Preview









Page 89

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







The Print Preview option for Charts allows you to specify margins, paper orientation, the level of

detail, and print settings. The changes are displayed immediately in the print view window. The page

margin lines, when visible in the View area can be moved directly by the single click and drag mouse

action.









Printing



Printing can be done in two ways:



 By clicking on the Print Direct on the toolbar:



This will directly send all the page(s) in the active document to the printer and print a

single copy of the active document.



 Selecting the print option from the File Menu:



This will display a dialog box where you can:



Specify the range of pages to be printed.



The number of copies to be printed.



Change of printer properties can also be done through this dialog box by clicking on the Properties

button next to your printer name.









Page 90

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Edit Options:

Copy



Click on the Copy toolbutton to copy the current chart to clipboard.

Clear All

Click on the Clear All toolbutton to Clear the current chart sheet.

Delete Output Sheet

Click on the Delete Output Sheet toolbutton to delete the current chart sheet.

View Options:

Normal View



Click on the Normal View toolbutton to display the current sheet in normal view (100%).

Zoom In

Click on the Zoom In toolbutton to increase the current sheet's view scaling by 25 %.

Zoom Out

Click on the Zoom Out toolbutton to reduce the current sheet's view by 25 %.

Settings



Click on the Settings toolbutton to customize your default Chart settings.









Page 91

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Report View







The Reports View allows viewing of ready made reports designed by CMIE. This option allows you to

change the indicator for which the current report is to be viewed, just by clicking on the indicator name.









To view a report:

 Click on an indicator name from the list in the Indicator Output sheet. You can also click on the

indicator name in the Select Indicator Name query Window.

 Click on the Reports View toolbutton from the Launcher Toolbar or select the Reports View

option from Launcher Menu. As a result, a Report Viewer window will be displayed.

 In the Select Report section, the Report list is displayed in a Structured Classification System.

The Structured Classification system consists of three nodes.









Page 92

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









 Indicators reports: Consists of reports designed by CMIE viewable for indicators selected by

the user.

 User's Indicator Notes: This node allows to view the notes written by you for the selected

indicator.

 Favourite Reports: You may include any of the CMIE designed reports which you need to

view more frequently in this node for easy navigability. Click on the required report name

under the CMIE Report and drag it to the Favourite Reports node. As a result, the selected

report will be included in the Favourite report node.

 Select the desired report by clicking on required report name.

 Click on another indicator to view the report. You can also use the arrow keys of your keyboard to

scroll down or up within the indicator list.









Page 93

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Tools Available







File Options



Save



When you click on the Save option, a dialog box is displayed showing the default directory where you

can save your report. This default directory is the working/ start in directory as specified in the program

shortcut properties.



The Save dialog box opens only when a file is saved for the first time.



To save a file in a different folder while using the Save option, do the following:



Select the appropriate drive from the "Save AS" box, or double-click a different folder in the folder list.





To save the file in a new folder, click Create New Folder.



In the File name box, type a name for the report.



Click on the Save button.



Export to Excel

The Export to Excel option allows you to save the current report as Microsoft Excel files (.xls). For

this Microsoft Excel is required to be installed on the Computer being used for accessing IAS .



To save a report as an Excel file:



 Select the Export to Excel option in File Menu.



 To save the report in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list.



 To save the report in a new folder, click Create New Folder.



 In the File name box, type a name for the report.



 Click on the Save button.



Print Preview



This feature allows you to preview the current report as it would be printed with the current Print

Settings.



 Click on Print Preview option in File Menu.



 The Two Page option allows you to preview two pages on the screen simultaneously. While in Two







Page 94

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Page mode, the button shows you the toggle option to revert back to the One Page mode.



 Zoom In and Zoom Out buttons allow you to magnify and reduce the size of the preview respectively.





 The Close button is used to exit from the Print Preview mode.



 Click on Print to send the sheet being viewed for printing.



Print Direct

This option allows you to directly print the selected report.

Print



Printing of the current report can be done in the following manner.



 Select the Print option from the File Menu:



This will display the Print dialog box where you can:



Specify the range of pages to be printed.



Specify the number of copies to be printed.



Change Printer properties by clicking on the Properties button.



Print Multiple



This option allows you to print multiple reports for a selected indicator. Select any of the required node

in the Select Report section and click on Print Multiple option. As a result, a Select to print dialog will

be displayed.



This displays all the reports included in that node in Select Reports to print dialog box.



 Select the reports required to be printed. For multiple selection, use the control or the shift key on the

keyboard while clicking on the types.



 To clear the selections click on Clear All button.



 To select all the reports displayed click on Select All button.



 Click on the Print button.



Print Multiple Direct



This option allows you to directly print multiple reports for a selected indicator. Select any of the

required node in the Select Report section and click on Print Multiple Direct option.



This displays all the reports included in that node in Select Reports to print dialog box.



 Select the reports required to be printed. For multiple selection, use the control or the shift key on the

keyboard while clicking on the types.









Page 95

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 To clear the selections click on Clear All button.



 To select all the reports displayed click on Select All button.



 Click on the Print button.





View Option:



Toggle Full Screen



This option allows you to view a report in full screen of the Report Viewer window. It is a toggle to hide

and view the Select Report Section.









Page 96

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Notes







This option allows you to record and save your comments and analysis of an indicator. It also allows

saving of notes as separate files and loading them one at a time for viewing, editing, adding and

appending one notes file to another.



The main notes view consists of two sections - the contents and the notes area:



Contents: This lists out all the notes in the file giving the indicator name, author of the notes, the date on

which the notes was created and a header for the note. All the fields except the indicator name can be

edited.



Notes: When you select a note from the contents section, it's details are displayed in the notes section

below it. You can select more than one note at a time. This options allows you to record and save your

comments and analysis of an indicator.







 Create Notes

 Select the required indicator name (SE) from the Output Sheet.

 Click on the Create Notes toolbutton or select the Create Notes option from the Edit

Menu. On doing so, a blank note will be appended to the Notes Window displaying the

Indicator Name(s), Author (login name on the PC), Date (current date) and Header

(blank).

 To enter your notes in the Contents section (Lower Half), click on the appropriate row in

the Headers section (Upper Half).

 To save the notes file click on the Save toolbutton or select Save from the File

menu. Important: Notes created by you will not get saved automatically. They have to be

saved to a file with a "not" extension.





 View Notes

 Click on the Notes View toolbutton to display the contents of the default Notes

file (you can change the default notes file in the Settings dialog box by selecting the Settings

option from the View Menu). To view previously saved notes, click on toolbutton or

select Open from the File menu. A dialog box is displayed. Select the correct path of the

Notes file (.not) and click on Open. After the Notes have been viewed and edited if

required, click on tool button or select Save from the File menu.

 The created notes can also be viewed in the Report Viewer.

 Select the desired indicator name from the Indicator Output Sheet.

 Click on the Reports View toolbutton from the Launcher Toolbar or select the Reports

View option from Launcher Menu. As a result, a Report Viewer window will be displayed.

 Select the User's Indicator Notes node. This will result in display of the notes for the

selected indicator on the right hand section of the Report viewer.





 Append Notes





Page 97

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 To append the entire or part of a notes file to your current notes file, click on the

tool button. An open file dialog box is displayed. Browse to the location of the notes

file to be appended and click on the Open toolbutton. A header list file displaying the

Indicator Name, Author, Date and Headers of all notes in the file opened is

displayed.

 Select the notes to be appended by marking them and click on the Append Button.









Page 98

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Analysis Worksheet







What is Analysis Worksheet?



Analysis Worksheet is like any other spreadsheet, which allows entering of data into a grid and perform

various analytical functions.





Its use in this Package



The primary reason to provide such an analytical tool as a part of the package is to give you quick access

to a basic tool to perform instant analysis on data.



When a query is performed, the results are shown in the Output Sheets . The data from these Output

Sheets can be easily copied into the Analysis Worksheet for you to work upon further. Copying can be

done using the standard copy/paste tools from the toolbar.



You can even paste data into the Analysis Worksheet from an external spreadsheet file like:

 Microsoft Excel® (.xls)

 Star Office® (.sdc)

 Lotus® 123 (.wk3)









File Options



Edit Options



View Options



Insert Options



Formatting Options



Right Click Menu









Page 99

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





File Options







Explained here are the various options that are available in this section:







Open



When you click on the Open toolbutton, a dialog box is displayed showing the default directory

where it expects your files to be. This default directory is the working / start in directory as specified in

the program shortcut properties. Select a file with a single click, from the available list and click on the

Open button.



To open a file from a different location do the following:



 In the Look in box, click the drive or folder that contains the file.



 In the folder list, double-click folders until you open the folder that contains the file you want.



 Double-click the file you want to open.



Save



When you click on the Save toolbutton, a dialog box is displayed showing the default directory

where you can save your file. This default directory is the working / start in directory as specified in the

program shortcut properties.



The Save dialog box opens only when a file is saved for the first time. When you click on the Save

toolbutton again for the same file in the same session, the file will get saved automatically without asking

for any confirmation, file name or location.

To save a copy of the file with a different file name or location, use the Save As option.



To save a file in a different folder while using the Save option, do the following:



 Select the appropriate drive from the "Save in" box, or double-click a different folder in the folder

list.



 To save the file in a new folder, click Create New Folder.



 In the File name box, type a name for the file.



 Click on the Save button.



Save As

The Save As toolbutton and File Menu option has the same functionality as the Save option

except that it allows you to save a copy of a file with a different file name.









Page 100

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





To save a file using the Save As option, do the following:



 Select the appropriate drive from the "Save in" box, or double-click a different folder in the folder

list.



 To save the file in a new folder, click Create New Folder.



 In the File name box, type a name for the file.



 Click on the Save button.



Save As Excel

The Save As Excel option allows you to save the current Analysis Worksheet as Microsoft Excel files

(.xls). For this Microsoft Excel is required to be installed on the Computer being used for accessing

Industry Analysis Service .



To save a file as an Excel file:





 Click on the Save As Excel toolbutton or select the Save As Excel option from the File Menu.



 To save the file in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list.



 To save the file in a new folder, click Create New Folder.



 In the File name box, type a name for the file.



 Select the Entire (entire worksheet) or Selection (selected cells) option, displayed at the bottom of

the "Save As Excel" box, as per your requirement.



 Click on the Save button.



Save As Text



The Save As Text option allows you to save the data from Output Sheets and Analysis Worksheet as

Text files (.txt).



Save a file as Text file:



 Select Save as Text file from File Menu or click on Save as Text file tool button.



 To save the file in a different folder, click a different drive in the Save in box, or double-click a

different folder in the folder list



 To save the file in a new folder, click Create New Folder



 In the File name box, type a name for the file.



 Select the Tab Delimited or Pipe Delimited option, displayed at the bottom of the "Save as Text file"

box, as per your requirement.







Page 101

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 Click on the Save button.



Set Print Area



Sets the selected cells as the area to be printed. Follow the steps given below for using this option.



 Mark the desired cells to be printed.



 Click on the toolbutton or select the Set Print Area option from the File menu.



 Only the selected cells will be printed when you give the print command.



Clear Print Area

Clears the print area setting. Click on the toolbutton to clear the print area, set previously for the

current sheet using the Set Print Area option.



Note: This will be disabled unless you have set up a print area using the Set Print Area option

Page Setup



The Page Setup option gives a dialog box where you can:



 Set the left, right, top and bottom margins for the page.



 Select centering of data on the page. This can be done by marking or unmarking the check boxes

labeled - Vertical and Horizontal



Vertical will center the data vertically on the page.



Horizontal will center the data horizontally on the page.



The following properties can be marked or unmarked as per your requirements:



 Row Header: Displays the row header as 1,2,3,4...etc



 Column Header: Displays the column header as A, B,C, D,E...etc



 Horizontal Lines: Displays horizontal grid lines



 Vertical Lines: Displays vertical grid lines



 Print Frame: Prints the grid border



 Only Black and White: Sets the document printing in black and white mode.



 Print Preview: Allows you to preview the page to be printed based on your page setup selections.



Print Setup





The Print Setup option allows you to change the following Print Settings:









Page 102

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 Printer properties



 Paper size



 Source of the paper (tray) in the printer and



 Orientation of paper - whether you want Portrait / Landscape.



Print Preview



Click on this toolbutton to preview the current Output Sheet or Analysis worksheet as it would be

printed with the current Print Settings.



 In this mode, you can navigate through all your desired pages to be printed by using the Next Page

and Prev Page buttons.



 The Two Page option allows you to preview two pages on the screen simultaneously. While in Two

Page mode, the button shows you the toggle option to revert back to the One Page mode.



 Zoom In and Zoom Out buttons allow you to magnify and reduce the size of the preview

respectively.



 The Close button is used to exit from the Print Preview mode.



 Click on Print to send the file being viewed for printing.



Printing



Printing can be done using one of the following two options:



Click on the Print Direct toolbutton on the toolbar:



 This will directly send all the page(s) in the active document to the printer and print a single copy of

the active document.



Selecting the print option from the file menu:



This will display the Print dialog box where you can:



 Specify the range of pages to be printed.



 Specify the number of copies to be printed.



 Change Printer properties by clicking on the Properties button.









Page 103

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Edit Options







Explained here are the various options that are available in this section.







Undo



Undoes the last action. If you have have performed an incorrect or unwanted action while in the

Analysis Worksheet then use Undo toolbutton to revert back to the earlier state.

Redo



Redoes the last undone action.



 If you need to recall the undone actions then use Redo toolbutton to do so.



 Redo will recall the actions till your last File Save action in the current session.



Cut



To move the contents of a cell to another cell use the Cut option.





 Click on the source cell.



 Click on the Cut toolbutton or select Cut option from the Right click menu or from the Edit

menu.



 To paste the contents to the destination cell, use the Paste option.



Copy



If you need to copy the contents of a cell to another cell then use the Copy option to copy the contents

of the source cell.





 Click on the source cell.



 Click on the Copy toolbutton or select the Copy option from the Right Click menu or from the

Edit menu.



 To paste the contents to the destination cell, use the Paste option.



Copy Formula



The formula of the current cell can be copied to another cell by using the Copy formula option.



 Click on the source cell.









Page 104

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







 Click on Copy Formula toolbutton or select the Copy Formula option from the Right



 Click menu or from the Edit menu.



 To paste the formula to the destination cell, use the Paste option.



Paste



To paste the copied contents of the source cell to the destination cell use the Paste option.



 Click on the destination cell.



 Click on the Paste toolbutton or select the Paste option from the Right Click menu or from the

Edit menu.



Copy Format



If you need to copy the format of the current cell to another cell then use the



 Copy Format option.



 Click on the source cell.



 Click on Copy Format toolbutton or select the Copy Format option from the Right



 Click menu or from the Edit menu.



 To paste the contents select the destination cell and use the Paste toolbutton.



Paste Format



The format of the cell, that was copied using the Copy Format option, can be pasted to the selected cell

by using the Paste Format option.





 Click on the destination cell.



 Click on Paste Format toolbutton or select the Paste Format form the Edit menu.



Clear Format



To clear format of selected cells use the Clear Format option.





 Select the required cells.



 Click on the Clear Format toolbutton or select the Clear Format option from the Edit menu.



Clears Cell Contents



The contents of the cells can be cleared by using the Clear cell option.







Page 105

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









 Select the required cells.



 Click on the Clear Cell toolbutton or select the Clear Format option from the Right Click menu or

from the Edit menu.

Delete Rows



To delete row(s) use the Delete row(s) option.





 Select the row to be deleted.



 Click on Delete Rows toolbutton or select the Delete Row(s) option from the Edit menu.



Delete Columns



To delete column(s) use the Delete Column(s) option.





 Select the column to be deleted.



 Click on Delete Rows toolbutton or select the Delete Column(s) option from the Edit menu.









Page 106

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





View Options







Explained here are the various options that are available in this section.







Normal View



This option zooms the current Analysis Worksheet to normal view (100%).



 Click on the Normal View toolbutton or select the Normal View option can be selected from the

View menu.



Zoom In



To increase the view size of the current Analysis Worksheet, click on the Zoom In toolbutton or

select the Zoom In option from the View menu. By default, the view size will be enlarged by 125 % of

the current view.



Zoom Out

To decrease the view size of the current Analysis Worksheet click on Zoom Out toolbutton or

select the Zoom Out option from the View menu. By default, the view size will be decreased by 75 % of

the current view.

Find



To search for a character or numerical string in the current Analysis Worksheet, use the Find option.



 Click on the Find toolbutton or select the Find option from the View menu.



 On doing so, a dialog box will be displayed.



 In the Find What text box, type the string required to be searched.



 If the search string exists in the file then, the cursor will be placed there highlighting the search string.



 If the search string does not exist in the file, a "Cannot find xyz" message will be displayed, where xyz

is the entered search string.



Settings



To customize the program settings, click on Settings toolbutton or select the Settings option from

the View menu.



Click here for more on Settings.









Page 107

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Insert Options







Explained here are the various options that are available in this section.







Insert Row



Inserts a blank row at current cursor position.



 Place the cursor in the position where you need to insert a blank row.



 Select the Insert Row option from the Right Click menu or from the Insert menu or clickon Insert

Row toolbutton.



Insert Column



Inserts a blank column at current position.



 Place the cursor in the position where you need to insert a blank column.



 Select the Insert Column option from the Right Click menu or from the Insert menu or click on Insert

Column toolbutton.



Append Row



Appends a blank row to the current Analysis Worksheet.



 The Append Row option can be selected from the Right Click menu or from the Insert menu or click

on Append Row toolbutton.



Append Column

Appends a blank column to the Analysis Worksheet.

 The Append Column option can be selected from the Right Click menu or from the Insert menu or

click on Append Column toolbutton.



Worksheet from File



This utility allows you to insert an existing worksheet file at your current cell location, which helps you to

work upon previously saved data and the current data in the spreadsheet.





 Click on Worksheet from File toolbutton or select the Worksheet from the File option from the

Insert menu.



 On doing so a dialog box will be displayed. Select the file which requires to inserted and click on

Open button.









Page 108

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







 This will insert the selected file at your current cell location.









Page 109

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Formatting Options







Explained here are the various options that are available in this section.







Format Cells



This option changes the format of the selected cells.





 Click on Format Cells toolbutton or select the Format Cells option from the Format menu or the

Right Click menu.



 On doing so the Format Cell editor is displayed. Here, you can:



 Change the font style of the contents of the cells.



 Change the foreground and background colour of the cells.



 Format cell border.



 Change text alignment.



 Change the cell format type - whether the data is a number, text, date etc.



 Make the desired changes and click on OK.



Increase Font Size



To increase the font size of the contents of the selected cell(s) use the Increase Font Size option. By

default, the font size will be increased by 1 point.



 Select the required cells.



 Click on the Increase Font Size toolbutton or select the Increase Font Size option from the

Format menu.



Decrease Font Size



To decrease the font size of the contents of the selected cell(s) use the Decrease Font Size option. By

default, the font size will be decreased by 1 point.





 Select the required cells.



 Click on the Decrease Font Size toolbutton or select the Decrease Font Size option from the









Page 110

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Format menu.



Bold



This option toggles font style - bold, for the contents of the selected cell(s).



 Select the required cells.



 Click on the Bold toolbutton or select the Bold option from the Format menu.



Italics



This option toggles font style - italics, for the contents of the selected cell(s).





 Select the required cells.



 Click on the Italics toolbutton or select the Italics option from the Format menu



Underline



This option toggles font style - underline, for the contents of the selected cell(s).





 Select the required cells.



 Click on the Underline toolbutton or select the Underline option from the Format menu.



Fill Colour



This option allows you to set the background colour of the selected cells(s).





 Select the required cells.



 Click on the Fill Colour toobutton or select the Fill Colour option from the Format menu.



 On doing so, the Colour editor is displayed. Select the desired colour and click on Ok.



Font Colour



To set the font colour of the contents of the selected cells(s) use the FontColour option.





 Select the required cells.



 Click on Font Colour toolbutton or select the Font Colour option from the Format menu.



 On doing so, the Colour editor is displayed. Select the desired font colour and click on OK.



Light Shading









Page 111

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





This option sets the background colour of the selected cell(s) to light Grey.





 Select the required cells.



 Click on the Light Shading toolbutton or select the Light Shading option from the Format menu.

Dark Shading



This option sets the background colour of the selected cell(s) to dark Grey.





 Select the required cells.



 Click on the Dark Shading toolbutton or select the Dark Shading option from the Format

menu.



Align Left



To sets the alignment of the contents of the selected cell(s) to left, use the Align Left option.





 Select the required cells.



 Click on the Align Left toolbutton or select the Align Left option from the Format menu.



Align Center



This option sets the alignment of the contents of the selected cell(s) to center.





 Select the required cells.



 Click on the Align Center toolbutton or select the Align Center option from the Format menu.



Align Right



This option sets the alignment of the contents of the selected cell(s) to right.



 Select the required cells.



 Click on the Align Right toolbutton or select the Align Right option from the Format menu.



Default



The Default option sets the cell format to default style. This option can be selected from the Format

menu or by clicking Default toolbutton .



Currency



To set the cell format to currency style, click on toolbutton or select the Currency option from







Page 112

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Format menu

Percent



The cell format can be set to percent style by clicking on the ercen toolbutton or by selecting the

Percent option from the Format menu.



Comma



The Comma option sets the cell format to comma style. This option can be selected from the Format

menu or by clicking Comma toolbutton .



Increase Decimal



To increase the precision of numeric contents of the selected cell(s) by 1, click on Increase Decimal

toolbutton or select the Increase Decimal option from the Format menu



Decrease Decimal



To decrease the precision of numeric contents of the selected cell(s) by 1, click on Decrease Decimal

toolbutton or select the Decrease Decimal option from the Format menu.



Angle Text Upwards



To angle the contents of selected cell(s) upwards, click on Angle Text Upwards toolbutton or select

the Angle Text Upwards option from the Format menu



Angle Text Downwards



To angle the contents of selected cell(s) downwards, click on Angle Text Downwards

toolbutton or select the Angle Text Downwards option from the Format menu.



Row Height



This option changes the height of the selected row(s).





 Select the required cells.



 Click on Row Height toolbutton or select the Row Height option from the Format menu.



 On doing so, a dialog box will be displayed.



 Specify the required row height and click on OK.



Column Width



To change the width of the selected columns(s), use the Column Width option.





 Select the required cells.









Page 113

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







 Click on Column Width toolbutton or select the Column Width option from the Format menu.



 On doing so, a dialog box will be displayed.



 Specify the required column width and click on OK.

Borders



This option changes the border style of the selected cell(s).





 Select the required cells.



 Click on Border toolbutton or select the Borders option from the Format menu.



 On doing so, the Format cells dialog box will be displayed.



 Make the desired selections and click on OK.



Conditional Formatting



To set the appearance of a cell based on its contents, use Conditional Formatting option.





 Click on Conditional Formatting toolbutton or select the Conditional Formatting option from the

Format menu.



 On doing so, the Conditional Formatting dialog box will be displayed.



 Specify the cell condition.



Example: If cell value >= 40 then appearance may be set to the following:

Font Style : Comic Sans MS



Font Colour : Red



Font Size : 14



Font Face : Bold Italic



 Click on Format and select the desired style.



 Click on OK.









Page 114

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Tools







Explained here are the various options that are available in this section.







Sort Rows



Row sorting can be done in three ways:



 Ascending:



This sorts the rows by the selected column in ascending order. Select the Ascending option from the

Sort Rows toolbutton, Right Click menu or from Tools menu.



 Descending:



This sorts the rows by the selected column in descending order. Select the Descending option from the

Sort Rows toolbutton, Right Click menu or from Tools menu.



 Multiple:



This option sorts the rows by more than one column at a time.



 Select the Ascending option from the Sort Rows toolbutton , Right Click menu or from

Tools menu.



 On doing so, a dialog box will be displayed. Select the columns from the left section on which

you want to perform the row sorting.



 On selecting the required column headers, you may shift the position of the column headers in

the right section (Selected Headers section) by using the drag and drop feature.



 You can toggle between ascending and descending option next to the column header in the

Selected Headers section.



 Click on Sort button to perform the required sorting.



Sort Columns



Column sorting can be done in three ways:



 Ascending:



This sorts the columns by a selected row in an ascending order. Select the Ascending option from the

Sort Columns toolbutton, Right Click menu or from Tools menu..









Page 115

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 Descending:



This sorts the columns by a selected row in a descending order. Select the Descending option from the

Sort Columns toolbutton, Right Click menu or from Tools menu.



 Multiple:

This option sorts the columns by more than one row at a time.



 Select the Multiple option from the Sort Columns toolbutton, Right Click menu or from

Tools menu.



 On doing so, a dialog box will be displayed. Select the rows from the left section on which

you want to perform the column sorting.



 On selecting the required row headers, you may shift the position of the row headers in the

right section (Selected Headers section) by using the drag and drop feature.



 You can toggle between ascending and descending option next to the row header in the

Selected Headers section.



 Click on Sort button to perform the required sorting.



Formula Assistant



 Click on destination cell of the Formula Result.



 Select Formula Assistant toolbutton or select the Formula Assistant option from the Tools Menu

or the Right Click menu.



 On doing so, the Formula Assistant dialog box will be displayed.



 Select the desired functions from the drop down list and click on OK.







Following are the functions available in the Formala Assistant:



AVERAGE: Calculates the average of the values of selected cells



COUNT: Calculates the number of cells selected



MEDIAN: Calculates the median of the values of selected cells



STD: Calculates the standard deviation of the values of selected cells



SUM : Performs addition of values of selected cells





 Mark the Source Data Cells for the Formula.









Page 116

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 Click on the OK button.









Page 117

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Right Click Menu







Some of the most commonly used tools are available in the Right Click menu.





 Place the cursor on the required cell.

 Click the right mouse button.

 This will display the list of tools available in the Right Click menu.





Following is the list of tools available in the Right Click menu:

 Undo

 Redo

 Cut

 Copy

 Copy Formula

 Paste

 Clear All

 Clear Cells

 Formula Assistant

 Format Cells

 Sort Columns

 Sort Rows

 Edit/Insert









Page 118

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Batch and Planner







The Batch Planner and the Planner Mode work in tandem to provide an utility to record the actions

performed by you so that you may repeat the steps for a particular output with a single click.



Example:

1. You have selected a certain search criteria

2. Upon which you filtered the data further by a certain parameter(s) and

3. Then sorted the data alphabetically.

The commands involved in performing the above actions can be saved in a batch file. There is no

restriction on the number of batch files that can be saved in the batch directory. Up to 10 batch files can

be saved for direct execution from the toolbar.



To run the same query again, run the saved batch file and get the desired output.







Organisation of Batch/Planner Window





The Batch/Planner Window has two sections viz.: Planner and Batch.



The basic difference between Planner and Batch is that a Batch records all the actions performed by

you when a query is run. Where as in the Planner Mode, the actions can be recorded without actually

executing them. The actions thus recorded from the Batch/Planner can be saved as batch files (extension

.bt).







The Insert button on this screen is enabled when the Planner section is active. Click on the button and

a dialog box will be displayed. Enter the command line of any action.







The Export button on this screen is enabled when the Batch section is active. This button allows

exporting the batch commands to the Planner section. To do this:



 Select the desired commands in the Batch section.



 Click on Export button to paste them to the Planner section.



You can also use the copy and paste utility from the toolbar to do the same.







The Refresh button refreshes the Planner and the Batch sections.









Page 119

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html









The Run Button is common for the Batch and the Planner section. It executes the selected commands

from either section.







The Run File Button shows the Open dialog box where you can select a particular batch file you wish

to run.







Toggle Planner Mode



Starts / Stops recording actions in planner editor.



Run Batch



Runs available batch files (up to 10).









Page 120

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Update Database







The Update Database is an utility to update the Industry Analysis Service database that is installed on

your systems.



The updates to Industry Analysis Service is available to you on a daily basis. At the end of each

working day, the updates to the database are generated, saved to update files and a zip file of these files

is uploaded to our website. These update files are then used to update the Industry Analysis Service

database installed on your systems.



To know what new data has been added, use the What's New utility in the Select Indicators module.



Steps to update the software database:



1. Insert the IAS CD in your CD-ROM drive.



2. Assuming your CD-ROM drive letter is "D", run the setup file from the



D:\ias_update directory.



3. Click Next on the welcome screen.



4. After the file copy click on Finish to complete the updation process.







Note: 1. In case of multi user setup it is required to have a complete access to the directory from

which the installation was intially carried out the server.



2. You need an administrator login if your server is running Windows NT or Windows 2000.









Page 121

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





How Does Update Work





 Select the source for the update files.

Note:



For the Web option, specify whether you want to start a fresh update or continue an earlier partially done

update.



Along with this, mention the number of times the software should attempt connecting to the server over

the Internet to perform the updates.

 The destination for Downloads/Updates has to be specified for the update files to be stored.

 Having selected the appropriate options click on the Update button to begin the update process.

 Once the update files are in place, the updation of the database starts automatically.

 Should you desire to stop the update process midway due to any reason, then click on the Abort

button.









Page 122

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Tutorial







Lesson 1: How to select indicators?





Lesson 2: How to use advanced options?





Lesson 3: How to generate charts from Output Sheets and Analysis Worksheet?





Lesson 4: How to generate charts from Select Indicators Window?





Lesson 5: How to display Report View?





Lesson 6: How to use Analysis Worksheet?





Lesson 7: How to search for new articles using Categorywise ?





Lesson 8: How to search for new articles using Text Search ?





Lesson 9: How to view PDF files of various industry sectors?





Lesson 10: How to view tables in PDF files as Microsoft Excel® files?





Lesson 11: How to print?





Lesson 12: How to save outputs as Industry Analysis Service , Microsoft Excel®, Text and Set

files?





Lesson 13: How to setup your computer for accessing Industry Analysis Service server

installation?









Page 123

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







Lesson 1









How to select indicators?



To select indicators you can use the following options from the Select Indicators Window:

 Embedded Search

 Run/Load Set









Embedded Search:

 The indicators can be searched using the embedded search by typing the indicator name in the text

box provided below the indicator list.

 Once you have selected the required indicators, run the query by using the Execute buttons .

 The result of the query is then displayed in the active Output Sheet .









Run/Load Sets:

 Here you are provided with CMIE Sets and User Sets.

 Check mark one or more sets that you wish to use and then click on one of the execute buttons -

Load Sets or Run Sets.

 Load Sets will simply load the selected sets with the frequencies and expressions that were saved

with those indicators.

 Run Sets will execute the selected sets based on their saved frequencies,expressions and will pick

up the output date that is entered in the Select Indicators Window along with query expression (if

any).The output of each set will be displayed in a separate Output Sheet.









Page 124

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 2





How to use Advanced Options?



Two advanced query options are available in the Select Indicators Window:

 What's New

 Query







What's New:

 This option facilitates viewing of indicators which were updated on one or more date(s) or date

range(s).

 The list of update dates are displayed in the New Data Available section of the What's New dialog

box. Double click on the required date or enter it in the Enter Date Range section of the What's New

dialog box.

 Enter multiple dates by separating them with a comma ",".



Eg: 16/07/2001,17/07/2001,18/07/2001

 Enter date range by separating two dates by a hyphen "-".

Eg:16/07/2001-20/07/2001

 Mark the required frequencies to be searched and then click on the execute buttons: AND or OR.

 AND: This execute command searches for the updated data for the given date range and

frequencies from the selected indicators and keeps only those indicators which have been

updated.

 OR: This execute command searches for any indicator(s) which have updated data for the

entered date range and frequencies in the What's New dialog box.

Query:

 The expression and date conditions can be specified to apply to the selected indicators in the Query

option.

 Type in the expressions in the Enter Expression area or select from the available list which is displayed

by clicking on the Select Expression button.

 The headers can be changed by clicking on the Change Header/s button.

 Give the appropriate date range for the query expression and click on OK.

 This will enable the query expression to be applied for the indicators. A green box next the Query

button indicates usage of the query in the Select Indicators window.

 To clear a query, click first on the Clear All button and then on OK. The Clear All tool button and

Edit menu option also clears the Advance Query option contents.









Page 125

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 3





How to generate charts from Output Sheets and Analysis Worksheet?

 Mark the data range to be plotted from an Output Sheet or Analysis Worksheet.

The data range selected should be a continuous range of cells and not two different ranges. If two

different ranges are selected then the last range selected will be plotted.



 Click on toolbutton or select Charts option in the Launcher menu.

 As a result, a Charts Viewer will be displayed. By default, the data will plotted as Line chart.

 You may change the chart type by selecting the desired type from the Chart drop down list.

 Checkmark against the Date Time in X-axis checkbox to view the precise date on the X-axis for the

data plotted.







You may also plot charts from Output Sheet based on CMIE/User templates. Click here to know more

about charts.









Page 126

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







Lesson 4







How to generate charts from Select Indicators Window?



 Select required indicator in the Select Indicators Window and click on toolbutton or select Charts

option in the Launcher menu.

 As a result, a Charts Viewer will be displayed. By default, the data will plotted as Line chart.

 You may change the chart type by selecting the desired type from the Chart drop down list.

 Checkmark against the Date Time in X-axis checkbox to view the precise date on the X-axis for the

data plotted.

You may also plot charts from Output Sheet based on CMIE/User templates. Click here to know more

about charts.









Page 127

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html







Lesson 5









How to display Report View?

 Click on an indicator name from the list in the Indicator Output sheet. You can also click on the

indicator name in the Select Indicator Name query Window.

 Click on the Reports View toolbutton from the Launcher Toolbar or select the Reports View

option from Launcher Menu. As a result, a Report Viewer window will be displayed.

 In the Select Report section, the Report list is displayed in a Structured Classification System.

The Structured Classification system consists of three nodes.

 Indicators reports: Consists of reports designed by CMIE viewable for indicators selected by

the user.

 User's Indicator Notes: This node allows to view the notes written by you for the selected

indicator.

 Favourite Reports: You may include any of the CMIE designed reports which you need to

view more frequently in this node for easy navigability. Click on the required report name

under the CMIE Report and drag it to the Favourite Reports node. As a result, the selected

report will be included in the Favourite report node.

 Select the desired report by clicking on required report name.

 Click on another indicator to view the report. You can also use the arrow keys of your keyboard to

scroll down or up within the indicator list.

Click here to know more on reports.









Page 128

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 6



How to use Analysis Worksheet?

Analysis Worksheet is like any other spreadsheet, which allows entering of data into a grid and perform

various analytical functions on the data.



When a query is performed, the results are shown in the Output Sheet(s). The data from these Output

Sheet(s) can be easily copied into the Analysis Worksheet for you to work upon further. Copying can be

done using the standard copy/paste tools from the toolbar.



 To open an Analysis Worksheet, click on tool button or select Analysis Worksheet from the

Launcher menu.

 Data can be imported into the worksheet from external speardsheet documents like MS Excel®, Star

Office® and Lotus 123® by clicking on tool button or selecting Worksheet File from the Insert

menu .

 Data can be saved as MS Excel® and text files by clicking on and tool buttons or selecting

Save as Excel file and Save as User file from the File Menu .

 A host of editing options are available to work with your data in the Analysis Worksheet.

 Cell formatting can be done using the various options available in the Format menu and toolbar.

Click here for more information on Analysis Worksheet.









Page 129

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 7

How to search for news articles using Catagorywise ?

 Click on tool button or select News -> Categorywise option from the Launcher menu.

 Click on the required Indicator from the Indicator section respectively.

 Select an appropriate operator.

 Enter the required date range in the Enter Date range to search for section.

 Click on the Execute buttons to view the news articles.

 The results will be displayed in Output Sheet .







Click here to know more on Categorywise search for news articles.



The news articles can be printed using tool button .









Page 130

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 8



How to search for news articles using Text Search?



 Click on tool button or select News -> Text Search option from the Launcher menu.

 Enter the required string in Word Auto Search section.

 Select an appropriate operator.

 Enter the required date range in the Enter Date Range to search in news articles box.

 Click on the Execute buttons to view the news articles.

 The results will be displayed in Output Sheet.







Click here to know more on Text Search for news articles.









Page 131

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 9







How to view PDF files of various industry sectors ?



 Click on tool button or select PDF Query option from the Launcher menu. This will display a

window which gives you tools to select your required documents.

 In the Select one/more Industry Sector(s) section, click on one or more sector names for which you

wish to view the documents.

 The Select from available dates section gives a list of the publication issues that may contain your

required documents.

 You can perform a word search within the available documents. To do this, unselect any sectors if

selected. Type in the keywords and click on the Find Documents button.

 Having selected the issues dates, click on the Find Documents button. This will list out all the

documents that are pertaining to the selected sectors within the given date range, in

the Found Documents section.

 You may double click on the document name in the Found Documents section or select the document

name and click on View.

 This will launch the PDF document in Acrobat Reader®.

 At the top right corner of the display screen, a list box is made available for quick navigation through

the list of found documents. Documents found in any further search can be added to this list box by

clicking on Add to View List button in the PDF Query window.

 Also, Prev and Next buttons are available for browsing through the viewed documents.









Page 132

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 10







How to view tables in PDF files as Microsoft Excel® files?

 Tables available in the PDF documents can be viewed as Microsoft Excel® files.

 When you move your mouse cursor over the table in the PDF document, the mouse cursor changes to

a hand symbol.

 Click on the table with this hand symbol. The data in the table will be exported to an Excel®

spreadsheet.









Page 133

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 11







How to print?



Printing of documents can be done by clicking on tool button or selecting Print from the File menu in

any of the views.

 In the Select Indicators Window, the print option will be enabled when you are viewing reports.

 In Output Sheets, Analysis Worksheet and Notes, you can print all the data or select specific data by

clicking on set print area tool button or selecting Set Print Area from the File menu and then

marking the data. A print command after this will print only the data marked by you.

 Reports and Charts can be printed directly by using the print command.









Related Topics:



Page Setup



Print Setup









Page 134

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Page Setup:



The Page Setup option gives a dialog box where you can:

 Set the left, right, top and bottom margins for the page.

 Select centering of data on the page.

 This can be done by marking or unmarking the check boxes labeled - Vertical and Horizontal

Vertical will center the data vertically on the page.



Horizontal will center the data horizontally on the page.







The following properties can be marked or unmarked as per your requirements:

 Row Header: Displays the row header as 1,2,3,4...etc

 Column Header: Displays the column header as A,B,C,D,E...etc

 Horizontal Lines: Displays horizontal grid lines

 Vertical Lines: Displays vertical grid lines

 Print Frame: Prints the grid border

 Only Black and White: Sets the document printing in black and white mode.

 Print Preview: Lets you preview the page to be printed based on your page setup selections.

Top









Print Setup:



The Print Setup option gives you a dialog box where you can:







Page 135

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





 Change the printer properties

 Select the paper size for printing

 Select source of the paper (tray) in the printer and

 Set the orientation of paper - whether you want Portrait/Landscape.

Top









Page 136

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 12







How to save outputs as Industry Analysis Service , Excel, Word, Text and Set files?



Outputs in Industry Analysis Service can be saved as:

 Industry Analysis Service files - Industry Analysis Service files (.boc), User Sets (.bsu), Analysis

Worksheet files (.aws)

 Microsoft Excel® files (.xls)

 Text files (.txt)







Industry Analysis Service files (.boc):



Industry Analysis Service file (.boc) type is a default for "Save" and "Save As" options in the Output

Sheets.



 When you click on or tool button or select Save or Save As from the File menu, a dialog box

is displayed with a default file extension (.boc) and the file can be saved in the location of your choice.







Industry Analysis Service files (.bsu):



Indicator list in Select Indicators window can be saved as User Sets file (.bsu).



 When you click on tool button or select Save Set from the File menu, a dialog box is displayed

with a default file extension (.bsu) and the file is saved in the User sets directory of the default working

directory of Industry Analysis Service .







Industry Analysis Service files (.aws):



Data from an Analysis Worksheet can be saved as Analysis Worksheet File (.aws).



 When you click on or tool button or select Save or Save As from the File menu, a dialog box

is displayed with a default file extension (.aws) and the file can be saved in the location of your choice.







Top









Page 137

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Microsoft Excel® files (.xls):



Data from Output Sheets and Analysis Worksheet can be saved as Microsoft Excel® files (.xls).



 When you click on tool button or select Save as Excel file from the File menu, a dialog box is

displayed with a default file extension (.xls) and the file can be saved in the location of your choice.

 You may mark and save selected items of the notes contents or save entire contents. This can be

specified in the Save as dialog box that is displayed.

Top









Text files (.txt):



Data from Output Sheets and Analysis Worksheet can be saved as Text files (.txt).



 When you click on tool button or select Save as Text file from the File menu, a dialog box is

displayed with a default file extension (.txt) and the file can be saved in the location of your choice.

 Select the format you want to save the text file in - Pipe Delimited or Tab Delimited.

 Click on save.

Top









Page 138

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Lesson 13







How to setup your computer for accessing Industry Analysis Service server installation?







 On your workstation, run Setup from the client directory within the IAS directory created on the

server during the Server Setup.

 The Licence Agreement will be displayed after which the Setup will prompt you for User and

Company Name.

 Next, Setup will prompt you for destination location for Industry Analysis Service program files.

The default path given is C:\CMIE\IAS, which can be changed.

 In the next step, enter the destination location for Industry Analysis Service database files on the

server. This will be the path that you have entered during the Server Setup for clients to access the

Industry Analysis Service database files.

 Check the confirmation list for your selections till this stage in the next screen. If you wish to change

any of these then use the Back button to do so or else click on Next button.

 After the file copy process, Setup will try and install HTML Help® on your computer. Installation will

be skipped if the software exists or a newer version is found. Complete the installation on the next

screen by clicking on the Finish button.









Page 139

ABC Amber CHM Converter Trial version, http://www.processtext.com/abcchm.html





Terms and Conditions







Information provided in Industry Analysis Service cannot be reproduced, published, sold or otherwise

distributed in any medium. Copying, transfer or distribution of any part of the software or the information

contained in Industry Analysis Service is prohibited.







Centre for Monitoring Indian Economy has taken every possible care to provide accurate and reliable

information and shall not be liable for losses or consequences, if any, arising from the use of the

information contained in Industry Analysis Service.







Disclaimer







All trademarks, trade names or company names referenced herein are or may be the trademarks or

registered trademarks of their respective owners.









Page 140