icp2011调查所用的软件介绍培训

1、Status, Data Transfer and ProcessingVilas Mandlekar, Nada Hamadeh and Yuri DikhanovICP Regional Coordinators Meeting7-11 March 2005, Washington DCICP Tool PackAgendaStatus Report ICP Tool Pack Work Flow and Data Exchange between Countries and RegionsData Processing Module DemoQ & ATool Pack Status U

2、pdatePrice Collection Module (PCM) Export to Excel - Price observations once entered can be downloaded to Excel for viewing or recording Impact on Data Transfer screen one new button“Cut and Paste” of observations from other sources (Excel) into the PCM multiple product data entry screenImpact on Mu

3、ltiple Products data entry screen one new icon on the gridOption to pute converted pricesImpact on Data Editing screen one new button that appears only if product parameters have changedTool Pack 1.2 whats changed since 1.1?Price Administration Module (PAM) No change in the screen layouts or text ap

4、pearing on screensItems (products/observations) beyond tolerance are highlighted in red in the Diagnostics Tables.Old Excel templates used in PAM 1.1 are NOT useable in 1.2Download blank templates for each of the Master data products lists, characteristics, characteristic values, specifications, out

5、lets and their mapping etc. “Cut and Paste” product lists etc. from old templates into the new templatesUpload into PAM 1.2Tool Pack 1.2 whats changed since 1.1?Data Processing Module (DPM) New module primarily for regional use, but also used by countriesRegion can create templates, i.e. selections

6、of products, locations, attributes etc., and time periods over which the countries provide their data Enter Exchange rates, population, expenditures, and weights (optional)Run Quaranta Tables, Index processing, and produce ReportsTool Pack 1.2 whats changed since 1.1?Data Processing Module (DPM) For

7、 ICP purposes, country use is limited to:Import a template from the Regional CoordinatorExport average or raw prices data to Regional CoordinatorTested by Statistics CanadaDPM User Manual and DPM Summary Steps preparedDPM Substantive Manual / Step-by-Step Guide underwayTool Pack 1.2 whats changed si

8、nce 1.1?What do Countries need to know about Tool Pack 1.2 ? Theres very little or no change between 1.1 and 1.2 in terms of functions of price observations data entry and running preliminary diagnostic reportsCountries receive from regions a selection of product lists and time periods over which th

9、e price observations are requiredCountries generate average prices data (Excel format) using the DPM module and send it to the Regional Coordinator Raw prices (optionally) can be sent by countries to the Region for index processingTool Pack 1.2 whats changed since 1.1?How do Countries/Regions upgrad

10、e to Tool Pack 1.2 ? RegionsInstall the PAM 1.2 after first un-installing the PAM 1.1 Input the product lists and any attributes (location attribute such as, Rural/Urban) for their countries, using new Excel templates in PAM 1.2Regions DO NOT normally NEED PCM to be installedCountriesIf they have a

11、PAM 1.1 already installed, then use the patch to upgrade to 1.2. Data entered under 1.1 will not be disturbed due to this upgradeThey can also install PAM 1.2 afresh if they want to enter their product lists and observations againTool Pack 1.2 whats changed since 1.1?Countries not using PCM can use

12、the Batch Upload Utility to upload their data into the PAM to perform data validationTried and tested by Statistics Canada in their pilot collectionStand-alone utilityFile for upload of observations must be in “CSV” formatBatch Upload User guide and CSV file formatBatch Upload Utility for Price Obse

13、rvationsCountries might require the help of RC team to convert their files into the CSV file formatFields in the file must follow a prescribed layoutProduct codes, UoM codes, UoM conversions must exist on the PAM before uploadUtility is in English i.e. the screens labels and messages are in EnglishB

14、atch Upload Utility for Price ObservationsTool Pack 1.2 Status of implementationTool Pack 1.2 Status of implementationOther news and issuesHHD ESCWA funded and specified a hand held computer based price collection module. To be finalized in Arabic and English by March end.Transferring Tool Pack soft

15、ware to Regional Coordinator Offices use of the World Bank FTP site or website for software upgrades/patches.Training of Regional Coordinators staff on DPM.Lessons from LAC pilot data collection3 types of problems:BugsErroneous use of the system by countriesNew functionalities requiredCountries have

16、 different levels of technological capabilitiesTool Pack needs close support from regional and global officesTroubleshooting capabilitiesAll documentation should be translatedTool Pack Workflow and Data ExchangeCountry PAM / DPMCountry PCM (s)2- Data Collection5- SetupRegion PAM / DPM9- Index Proces

17、singObservationsSurvey Details1- Setup4- Data Validation7- Data Transfer to/from RegionPAMDPMAverage Price TemplatesIndividual or Average Prices8- InterCountry Validation6- Data Transfer to/from Country3- Data Entry and Editing10- ReportsCountry PAM1- SetupProductsAttributesOutletsPrice CollectorsMa

18、pping Products Outlets Price CollectorsSurveysSurvey DetailsXML fileSurvey products, outlets and price collectors detailsCountry PCM (s)2- Data Collection:Printing Data Collection Forms3- Data Entry and Editing:Data EntryData EditingOutlier AnalysisObservationsXML fileIndividual observations (includ

19、ing outliers if the country chose to keep the outliers)Country PAM4- Data Validation (Diagnostic Reports)Product Level Diagnostics Table 1Observation Level Diagnostics Table 2Region PAM / DPM5- SetupProductsAttributesPopulationExpendituresExchange RatesRegion PAM / DPM6- Data Transfer to/from Countr

20、ySend Average Price TemplatesReceive Average Prices + IndicatorsReceive Individual PricesAverage Price TemplatesAnalytical template XML fileMeans of data selection to ensure data qualityDetermines timeframe coverage, product selection, breakdown by outlet types, and attributesAverage prices + indica

21、tors (coefficient of variation)Country DPM7- Data Transfer to/from RegionReceive Average Price TemplatesSend Individual pricesSend Average prices + indicatorsBy outlet types? By attribute breakdown?Individual or Average PricesIndividual prices (preferred) - xml fileAverage prices + indicators (minimum requirement to run Quaranta Table) - Excel fileIndex processing can be run with individual prices or with average prices.Region PA