Transcript Slide 1

Compiling a Services Producer Price
Index using IMF developed
Price Index Processor Software
Niall O’Hanlon, CSO Ireland
Content
• Current SPPI compilation in Ireland
• Outline of PIPS software primarily using
screenshots
• Initial CSO experience of PIPS
• Future developments
Work in Progress!
Interim Processing using Excel
PIPS software
• http://www.unece.org/stats/downloads/SW_
CPI_PPI/pips.html
• Software, source code, manual and discussion
forum.
• Software is Visual Basic running on Microsoft
Windows. Database stored on Microsoft
Access, SQL or SQL Express.
Main Menu Screen
Add New: Allow users to enter new
establishments
Edit: Allows users to edit
establishment details/products details
and enter price information
Data Check: Used before index
compilation to check for errors
Review Data: Before Index
Compilation
Compile: Allows Index Compilation
TS Report: Allows for Times Series
Reports to be compiled
System Config: Allows users to set up
database properties.
System Configuration Screen
Establishment Screen
This allows you to
enter multiple
establishments at one
time through Excel
upload
This allows you to
enter company
products
Establishment Batch Upload Screen
Entering Weight/Product/Transactions
Company Weight
entered here –
turnover of
company
Transaction weight
Transaction List created by user to
represent the items company are
pricing.
Click to add new
product group
Click to enter
prices of
transactions
Price Input Screen: Option 1
Click on Pink Button to
enter prices via Option 2
You can select the period to enter
price for by selecting Set
Compilation Date on this screen
Price Input Screen: Option 2
Allows you to add new month to insert price
You can set this to reflect
your threshold system for
validation
Price Preview Screen
Detection of Outliers
Compilation of Indices
Time Series Report
CSO Experience
• We are still testing! Hope to move to parallel
running over the next few months.
• If everything goes to plan we would like to use
PIPS exclusively from the 2010 rebase.
• This would involve some changes to our
methodology.
• Some issues such as monthly periodicity
• User friendly, flexible and stable
Some suggestions for future
development
Further refinement and support by the
community of users
• Quarterly periodicity option
• General support
• Enhancements to the Manual including an
Excel based work through of a sample index