Home

ICP Country Software

1. sessi 51 2 2 9 5et MinMax Price ROTO EIE era Eae RO ut pe 53 5 2 6 Set coeficient Of Variation ete ae danena oi 54 5 2 7 View Observation Details seme suit beet m exire Eni Mem dE 55 5 2 8 DOE mags n 58 5 2 9 SOE T HOMO 59 5 2 10 Modify Observation Details ccccccccssesscccccnessecccnsusseccscaussecessaunsecessaueeesssaesecsssuuseeesaaensees 59 5 2 11 X Save Validated Observations scccccsseecccsssseccsssccsauseccsuueecsauseessaseessasesssuusessasecesausesssaases 60 S212 REL 60 5 2 13 Change the row highlighting color of the rejected 61 Page 2 of 73 6 5 2 14 Change the row highlighting color of the invalid 62 52 15 Change the Default DatdD0se 5 o o eo eatenus sd Roue aa prd ud 63 5 2 16 Export Average Prices and Observation Details eee 65 COMMON CONTROLTEATURES 5 cepe sepa RE SNR RE FRE S ER ERE UR PP EUR EU ERES UR Ne NOS 69 6 1 GRID ON 69 6 1 1 Edd 69 6 1 2 ROG OlO cet ates Dees asa a
2. Data Validation and di ange Database e Print Help Exit 51 C WikhillProject ICP_Round2 Development Products v File Name v From Date 2009 10 17 53 C Indude validated observations Get Data Location v Location Type v To Date 2009 12 17 Click here to view selected filters Outlet v Outlet Type v Averaging Method arithmetic Mean vi Export J MinMax Price Ratio Limit 0 6 EH v Var Coefficient Limit 5 E vj Tolerance Ratio Limit 0 6 v Tvalue Limit 1 Cancel Products Observations Quotations Product Name Product Code No of Price Quotations Average Price Min Price Max Price Min Max Price Ratio Var Coefficient Figure 4 2 15 1 Change Default Database Data Validation and Averaging application Click on the button which is available next to the Change Database field as shown in the screenshot 4 2 15 1 gt t will display a file Selection dialog box screen as shown below Locate the database file which you want to use in the Data Entry application and click on Open button ad Open m M o dr i i gt gt Personal ICP test lll Search Mi Organize Views Me New Folder Favorite Links o M M
3. 5 cance Products Observations Quotations Rejected Product Code Product Name Location Type Outlet Code Obd fl Basic Heading BASHATI INDIAN 101101101 Basmati TRDA Bagged Indian Kg 13 As Seeb 1 58 Merket33 1 2009 01 01 51 Klogram s 101101101 Basmati TELDA Bagged Indan Kg 13 As Seed 1 57 Maket32 1 2002 01 01 51 Kiogram s lid 101101101 Basmati TEDA Bagged indan Kg 12 Bawshar 1 56 Maket31 1 2003 01 01 51 Klogram s 101101101 Basmati TILDA Bagged Indan Kq 12 Bawshar 1 56 Market31 1 2009 02 01 51 Kiogram s 101101101 Basmati TILDA Bagoed indan xg 13 As Seeb 1 57 Maketz2 1 2009 02 01 51 Klogram s I 101101101 Basmati TILDA Bagged indan Kg 13 As Seeb 1 58 Maket33 1 2009 02 01 51 Kiogram s m 101101101 Basmati TILDA Bagged indan Xg 13 Seeb 1 58 Market33 1 2009 03 01 51 Kilogram s 101101101 Basmat TRDA Bagged indan Kg 13 Seeb 1 57 Market32 1 2009 03 01 51 Klogram s 101101101 Basmat TADA Bagged indan SKg 12 Bawshar 1 56 Market 31 1 2009 03 01 51 Klogram s 101101102 BammatiMagbool BAGGED INDIAN 20Kg 12 Bawshar 1 56 Market31 1 2009 03 01 21 Klogram s 101101102 BasmatiMaqbool BAGGED INDIAN 20Kg 13 Seeb 1 57 Merket32 1 2009 01 01 21 Klogram s a I 101101102 Bssmati Meqooci BAGGED INDIAN 2OKg 13 As Seeh 1 58 Merket33 1 2003 02 01 21 Kiogram s iu 101101102 Basmati Msqbool BAGGED INDIAN 20Kg 12 Bawsher 1 56 Market 31 1 2009 0241 23 1 Klogram s 10
4. To date 2009 12 17 9 Cancel Export lick here to vi i filter v Rejected Observations Observations ref UoM Pref Obs Obs UoM C Obs Ob Conv Prev Price Collector N Curre Currency Exchange R Comm Last Exported File N Prev E Reje Iz 3 Gram s 28 00 2 Gram s 0 05 0 06 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 05 0 06 pc3 OMR 1 0 ERE Gram s 70 00 2 Gram s 0 06 0 08 pc3 OMR 1 0 Rejected Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Gram s 28 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 Dc2 OMR 1 0 Millilitre s 200 00 5 Millilitre s 0 06 0 08 DC3 OMR 1 0 7 Gram s 28 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 m Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 m Gram s 28 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Millilitre s 200 00 5 Millilitre s 0 06 0 08 DC3 OMR 1 0 Gram s 28 00 2 Gram s 0 06 0 08 Dc2 OMR 1 0 m Gram s 70 00 2 Gram s 0 06 0 08 3 OMR 1 0 m Millilitre s 240 00 5 Millilitre s 0 07 0 09 DC3 OMR 1 0 Millilitre s 200 00 5 Millilitre s 0 07 0 09 DC2 OMR 1 0 Millilitre s 240 00 5 Millilitre s 0 07 0 09 DC3 OMR 1 0 Millilitre s 200 00 5 Millilitre s 0 07 0 0
5. 10110202 6 i if MP Brovm Flour NO 1 Maida Plst Bag OMANFLRMILL SKg 10110203 6 GOB pasta 101103 Vermicelli Pasta PLS PAPER KOLSON U A E 450 g 10110301 E Hr Vermicelli Pasta Al Khaleejia U A E 453g 10110302 i iP Vermicelli Pasta PLS PAPER SIPA France 453g 10110303 6 GOB macaroni 101104 HI Macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 6 Sphagatti Long PAPER BOX HONIG HOLLAND SO 0g 10110402 6 LQ Macaroni Cut PAPER BOX HONIG HOLLAND 50 0g 10110403 6 eo f LEBANON BREAD 1011051 HL Lebanon Bread NO Name 3piece 101105101 8 Lebanon Bread Large NO NAME 3piece 101105102 Mff Lebanon Bread SMALL NO NAME Spiece 101105103 6 GOB BREAD SLICED 1011052 LD a Medium Bread SLICED amp WHITE MODERN 530g 101105201 4 O Small Bread Sliced amp White NO Name 400Pack 101105202 6 5 2 5 Figure 4 2 4 3 Validate and Average Observations Set MinMax Price Ratio Limit To set MinMax price ratio Limit change the value provided in the MinMax Price Ratio Limit field If the MinMax price ratio for a product is less than this value then its MinMax price ratio cell will be highlighted with the color shown in the Color selection box that is available next to the MinMax Price Ratio Limit text field Each time you modify this value you need to click on the Validate Average button to refresh the highlighting Formula for Calculating MinMax Price Ratio
6. Download data entry templat Products From date 2009 04 04 GetData Import C Data Entry Mode INN Invalid Observations v Tedate 2009 12 16 cancel Export Click here to view selected filters E v Rejected Observations Observations MR em tra RN 2009 04 01 241202 Men Sandals Gazala 3050 Oman 1 Bawshar Market71 1 Urban 2009 04 01 451001 ALuminum Foil DIAMOND 200 SQ FT U S A 200sq ft 13 As Seeb 57 Market32 1 Urban _ 2009 04 01 1023603 Tomato Ketchup MAGGI 325 13 As Seeb 103 Market 63 1 Urban 2009 04 01 211301 Turban Wool Masar Medium ST DD India Kashmir 1 12 Bawshar 94 Market 54 1 Urban _ 2009 04 01 101101102 Basmati Maqbool BAGGED INDIAN 20Kg 13 As Seeb 58 Market 33 1 Urban 2009 04 01 1021502 Diary Milk Chocoalte CADBURYS ENGLAND 49 g 12 Bawshar 56 Market31 1 Urban m 2009 04 01 101418101 Quality Chedder Cheese Tin KRAFT Australia 226g 12 Bawshar 56 Market31 1 Urban 2009 04 01 101311703 Agam Barracuda 1Kg 11 Mutrah 1 Marketi 1 Urban _ 2009 04 01 10123202 Beef Franks AL Kabeer U A E 454g 13 As Seeb 103 Market 63 1 Urban m 2009 04 01 1023602 Tomato Ketchup Kimball Malaysia 340g 12 Bawshar 105 Market 65 1 Urban 2009 04 01 101611101 Red Apple U S A 1Kg 14 Al Amrat 13 Maket8 1 Urban 2009 0401 1019401 Mixed Nuts SALTED BEST UAE 1 50g 12 Bawshar 66 Market40 1 Urban _ 2009 04 01 450603 Liquid Disinfectant
7. mE O 4f Sphagatti Long PAPER BOX HONIG HOLLAND 50 0g 10110402 6 0 323 0 294 0 345 0 852 7 Macaroni Cut PAPER BOX HONIG HOLLAND 50 09 10110403 6 0 335 0 295 0 375 0 787 a m 1Nn11NS1 Figure 4 2 5 1 Set MinMax Price Ratio Limit 5 2 6 Set Coefficient of Variation Limit To set Variation Coefficient Limit change the value provided in the Var Coefficient Limit field If the Var Coefficient for a product is more than this value then its Var Coefficient cell will be highlighted with the color shown in the Color selection box that is available next to the Var Coefficient text field Each time you modify this value you need to click on the Validate Average button to refresh the highlighting gt Formula for Calculating Coefficient of Variation CoV STDEV Converted Price AVG Converted Price 100 Page 54 of 73 HE Data Validation and Avcraging Oman CTRY HHC DB 9 Decs3db 8 Em 85 8 Change Database T Wikhil Provect ICP_Round2 Development mun Prodi cts v File Name v From Date 2008 01 27 C Indude vaidated observations Locaton Location Type v To Date 2009 12 17 dick here to view selected filters j Cutlet v Outlet Tyre AveragingMethod sritrmetc Mean MinMax Price Ratio Limit 0 9 m v Var Coefficiert Limit 5 E v Tolerance Ratio Linit Ez Tvalue Limit 1 E v Products Obse
8. International Comparison Program 07 01 ICP COUNTRY SOFTWARE Household Consumption Items User Manual Version 1 0 Global Office 2nd Regional Coordinators Meeting April 14 16 2010 Washington DC 1 wr d 1 1 1 2 1 3 5 1 5 2 Contents EAA E AE Q 4 ABOUTTHE OUIDE 4 SCOPE 4 4 SYSTEM Fn E UE UU EU ES 6 TECHNICAL ARCHITECTURE FOR ICP COUNTRY SOFTWARE cssccsscssccsscssccsccsscsscesccsscsscesccsscsees 7 SOFTWARE TINS HR 9 HOUSEHOLD PRICE COLLECTION MODULE FEATUREG csscssccsscssccsccssccsccsscsscsscsscsscescsscssoeses 12 DATA INT ees ec 13 5 1 1 Launch the Data 13 5 1 2 Setup Survey Setup Import Data Initial Setup cccccccccccesseeeeeeeesececcccccscscscecseeueeeeseeeceseesess 14 5 1 3 Export Survey 6 18 5 1 4 Aud Locations and QUT CES rt Er RR NU b
9. Tvalue Limit 1 fv Cancel Products Observations Quotations Product Name Product Code No of Price Quotations Average Price Min Price Max Price Min Max Price Ratio Var Coefficient Figure 4 2 3 1 Filter Observation Summary 5 2 4 Validate and calculate Average Prices for Products gt Once you have loaded the Observation Summary for products by following steps as mentioned in section 4 2 2 or 4 2 3 you can click on the Validate Average button Page 51 of 73 E Data Validation and Avcraging Oman CTRY HHC DB 9 Decs3db Change Da abase amp print 8 we O cat T Nikhil Project ICP _Round2 Developmeni uus P ndi ct v File Name v From Date 2009 01 27 _ Indude vaidated observations Locaton v Location Type v Date 2009 12 17 e dick here to view selected filters Cutlet v Outlet Tyre v AveragingMethod srittmetc Mean MinMax Price Ratio Limit 0 9 E v Var Coefficiert Limit 5 E v ToleranceRato Limit C6 E v Limit 1 Products Observations Quotations E E BASMATI IND AN C Basmat TILDA Bacged Indian 5Kg 1011011561 6 C Basmat Maqbool 3AGGED INDIAN 20Kg 1011011C2 6 SE Basmat Al Jabal Al Akhcar ndia 45Kg 101101103 8 C PAKISTANI 1011012 if Basmat PAKISTANI 1Kg 1011012501 6 4 Basmat GUARD Bagged Pakistan 5Kg 101101202 z iif Mf Basmat KFANG
10. While validating existing observations using the Data Validation and Averaging application any observation can be marked as Rejected by the user The rejection could be based on certain rules guidelines which will be followed by the user who validates the Observations If an observation is already rejected the Observation Quotation grid will display Rejected in the Rejected column and will be highlighted with the color set selected in the Rejected Observations color selection box To reject observation follow the steps as mentioned below gt Load the Observations by following the steps mentioned in section 4 2 7 gt Navigate to the observation you want to reject gt Click on the Rejected field Page 60 of 73 Select Rejected Click on Save A drop down will be shown with two options Rejected and empty Repeat these steps for all observations that you want to Reject You can also change the status of rejected Observation by selecting empty option available in the drop down shown in the Rejected drop down After making this change click on Save Data Validation and Averaging Oman CTRY_HHC_DB 9 Dec s3db B e O ext Products File Name Location Location Type Outlet Outlet Type MinMax Price Ratio Limit Em Var Coefficient Limit Products Observations Quotations Invalid Observations Rejected Observ
11. 1 Using Excel View the Error Details by clicking on the View Error Details Hyperlink and then modify the corresponding Observations in the Data entry Template excel file Savethe Excel file gt Import it again by following the steps mentioned in Section 4 1 8 gt Click on Save button that is available on the Top left corner of the Main Data entry screen 2 Onscreen Modification gt You can navigate to each row which is highlighted read error details by either reading the tooltip for that row or by clicking on the View Error Details Hyperlink gt Correct the data in all highlighted rows gt Click on Save button that is available on the Top left corner of the Main Data entry screen Page 27 of 73 5 1 11 Save Imported Observations Once the Observation Data import is completed successfully Click on Save button that is available on the Top left corner of the Main Data entry screen f there are some duplicate records system will display a confirmation message as shown below Figure 4 1 11 1 Saving with duplicate Observations Validating Clicking No will stop save gt Ifyou click Yes or if there were no duplicate observations system will first validate the observations and display the wait message as shown below Loading Data Please Wait Validate Observations Figure 4 1 11 2 Saving Observations Validating gt It will start saving observations and display wait me
12. Center 7 0s S2 Conditional J Format Painter L ci Merge Center 4 h sahil Formatting a Clipboard Du Alignment Number zl g Errors Listed on 12 16 2009 3 56 24 PM ROW NUMBER Error Text 4 Product Code empty 7 Outlet Code empty 13 Outlet Code empty 14 Location Code empty 7 8 9 Figure 4 1 8 7 Observation Data Import Error Log All the observations which were present in the Data entry template will be loaded in the Data entry screen and invalid observations will be highlighted as shown in the figure 4 8 6 5 1 9 View Import Errors If importing Survey Setup Data or Observations fails the system will display an error message as shown in section 4 1 2 and 4 1 8 To view the error details you can click on the view Error Details hyperlink which will open an Excel sheet which will have all the error details which cause the import failure Refer figure 4 1 8 6 and 4 1 8 7 Page 26 of 73 Import errors for observations can also be seen by moving the mouse cursor over the highlighted rows as shown in the figure below The error details will be shown in the Tooltip of the row Bul Data Entry Oman CIRY HHC DB 3db NN 8 wo pae Pah e A gt it D ta Entr 4701 a led sae 56 Delete Gd Preview m view amp Products Fromdate 2009 10 16 Ea
13. m a Vermicelli Pasta Al Khaleejia U A E 453g 10110302 6 m if MP Vermicelli Pasta PLS PAPER SIPA France 453g 10110303 6 SOB macaroni 101104 m Mf Macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 6 m Hg MF Sphagatti Long PAPER BOX HONIG HOLLAND SO 0g 10110402 6 i M Macaroni Cut PAPER BOX HONIG HOLLAND SO Og 10110403 6 0E LEBANON BREAD 1011051 m oO Lebanon Bread NO Name 3piece 101105101 8 Figure 4 2 2 3 Observation Summary for Products gt Inthe screenshot above you can see that the Observations Summary all products as per filter is loaded in the Tree format gt Initially this tree will be loaded only with Product Codes Names and number of Observations available for each product Clicking on Validate Average button will calculate and load other detail which is described in the section 4 2 4 5 2 3 Filter Observations Summary There are ten filter criteria available in the Data Validation and Averaging application which can be used for filtering the existing observations and summary From Date Observation Date of the observation should not be before this date This is a mandatory filter criterion To Date Observation Date of the observation should not be after this date This is a mandatory filter criterion Averaging Method Method to be used for calculating Average price for products Products This field shows a list of all available products in the form of a tree
14. t Personal ICP qr m Favorite Links Man i test El Data Entry XLS Data Entry Template XLS E Documents More Folders 18 Computer EP Network E Control Panel Recycle Bin Ji Personal di Code di ICP Entry Apr2009 XLS El Data_Entry_Feb XLS E OMN_HHC_RawPrices_20010301_20091210_v XLS OMN_HHC_RawPrices_20081009_20091209_12 XL OMN HHC RawPrices 20090127 20091204 wv XL EE OMN RawPrices 20090609 20091215 v12 X BS OMN RawPrices 20091002 20091202 5656 BS OMN RawPrices 20091002 20091202 bnb BS OMN RawPrices 20091003 20091203 03 XL Ca a E File name Data Entry Template XLS Save as type Excel Files XLS w Hide Folders Figure 4 1 7 2 Save Data Entry Template File Page 22 of 73 gt Data Entry Template download will start and system will display a wait dialog message as shown below Loading Data Please Wait Exporting Data Entry Template Ha Figure 4 1 7 3 Download Data Entry Template File Wait Message gt Once the Template is downloaded successfully System will display message Exported Successfully Figure 4 1 7 4 Download Data Entry Template File Completed 5 1 8 Import Observations The Data entry application provides three ways of entering a new Observation 1 Using the data entry Template which is described below in this section 2 Using the Exported Observation sheet which is describ
15. 0 2009 04 01 10222401 57 400 00 2 1 39 1 74 DC3 OMR 1 0 Figure 4 1 12 3 Entering new Observation Data Entry Entering an invalid code in these columns displays an error message and blanks out that column For example if you enter an invalid Product code and try to navigate to the next column by hitting the Tab button or mouse system will display a message as shown below along with the code entered by you Validate Figure 4 1 12 4 Invalid Code Message Data Entry gt Ifyou want to enter more than one observation then keep after completing the data entry for first observation hit tab on the last column It will add the newly entered observation to the Observations grid and add a new empty row on the top Now you can add a new observation Keep on repeating these steps until you have added all the observations gt Click on Save button that is available on the Top left corner of the Main Data entry screen Now follow steps as mentioned in section 4 1 11 Page 31 of 73 5 1 13 Change on screen Data entry mode As mentioned in section 4 1 12 there are two modes available for the data entry in the Observations grid Data Entry Mode or Speed Mode and Detailed View mode You can switch between these two modes by checking or un checking the Data entry Mode Checkbox Download data Products v Fromdate 2009 02 26 E MI Import IN Invalid Obser RUNE
16. 1 0 _ Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Milllitre s 200 00 5 Mililitre s 0 06 0 08 DC3 OMR 1 0 Gram s 28 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 m Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Gram s 28 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 L Militre s 200 00 5 Mililitre s 0 06 0 08 DC3 OMR 1 0 Gram s 28 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 m Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 Milllitre s 240 00 5 Mililitre s 0 07 0 09 DC3 OMR 1 0 m Milliitre s 200 00 5 Mililitre s 0 07 0 09 DC2 OMR 1 0 L Mililitre s 240 005 Mililitre s 0 07 0 09 DC3 OMR 1 0 Militre s 200 00 5 Mililitre s 0 07 0 09 DC2 OMR 1 0 m Gram s 198 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 m Milliitre s 200 00 5 Mililitre s 0 08 0 10 DC3 OMR 1 0 m Gram s 195 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 _ Gram s 198 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 Mililitre s 200 00 5 Mililitre s 0 08 0 10 DC3 OMR 1 0 m Gram s 195 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 Figure 4 1 21 1 Change Rejected Observations color 5 1 22 Change the row highlighting color of the invalid observations Similar to Rejected Observations the back color of Invalid observations in the Observations grid is customizable You can select any color that is available in the Invalid Observations
17. 12 16 E Cancel Export Click here to view selected fiters EX Rejected Observations Observations ObsDate ProductCode Location Code OuiletCode Obs Qty Obs UoMCode ObsPrie Conw Price PnceColector Name Cumency CumencyUn amp ExchangeRate Comments E 20090401 10111101 13 57 p 2 00 1 0 41 0 62 DC3 mR 1 0 me Tu 209 0401 241202 12 111 1004 15 40 15 40 DC2 oR 1 0 lameosat 451001 13 57 1 00 4 189 189 DC3 OM 1 00 4 B 80 8 80 DC2 15 64 DC3 2000 0491 211301 12 2008 0401 101101102 13 2009 0421 1021502 12 49 00 0 22 0 27 DC2 2009 04 01 101418101 12 225 00 0 65 0 81 DC2 2008 0401 10131103 11 1 L00 1 0 44 0 44 DC1 8 Bo B s z 29 N 3 N oN g z 4 E 3 3 m m L gt je jw we 82233 25 0401 10511001 14 B 1 00 1 0 50 0 50 DC4 o b axeosoi 1019901 2 55 150 00 2 0 74 0 93 DC2 o 0 aoso 450505 B 55 750 00 5 135 169 DC3 o 0 1090401 910902 13 58 1 00 51 135 135 DC3 b ameoeot 90103 2 50 00 0 39 0 43 DC2 o b ameo4ot 10 42 03 2 55 30 00 4 115 1 DC2 o 0 a040 10105202 13 58 400 00 4 0 11 0 14 DC3 o b axeosot wun 1 Hu 1001 0 55 0 55 DC2 o 0 4 mam 3 57 400 00 2 1 39 174 13 on 0 E Remdiof1632 gt Figure 4 1 8 6 Observation Data Import Error Hyperlink Wrap Text y Qut TT B Calibri uu cu 33 Copy Paste iE EE Sd Merge amp
18. 20091207 vwv XLS 12 7 2009 5 42 PM HHC RawPrices 20091007 20091207 vvvv XLS 12 7 2009 5 43 PM Music Searches Public Ba Region_Master_List 03 dec XLS 12 3 2009 9 57 AM BEI test 2000 Records xls 12 15 2009 12 31 TATE LL I Figure 4 1 2 2 Master Data Excel File Selection Page 16 of 73 Select the Master List Excel file that is sent by the region and modified Saved by you Click Open System will start the data setup process by first validating the data in all worksheets and then importing and saving it in to its own database While import is in process a wait dialog along with a progress bar will be displayed Loading Data Please Wait Initializing Setup Data Import a 1 B J Figure 4 1 2 3 Survey Setup Data Import progress gt If there was no error in the data system will complete the import and display Import successful message as shown below and populate Country detail e g Country Name Local Currency and Foreign Currency if there is any etc on the Survey setup screen Figure 4 1 2 4 Survey Setup Data Import Completed gt Incase the Excel file has invalid or incorrect data in e g Location name is empty UoM Code is empty Same record added twice in a worksheet the Data setup import will fail and display an error as shown below Figure 4 1 2 5 Survey Setup Data Import Error Message It will also display a Hyperlink View Error Details
19. 3 343 3 075 238 0 809 Basmati Maqbool BAGGED INDIAN 20Kg 101101102 6 11 122 10 765 11 375 0 946 2 Taf Basmati Al Jabal Al Akhdar India 45Kg 101101103 8 13 098 12 502 13 75 0 909 3 G Basmati PAKISTANI 1011012 Basmati BOX PAKISTANI 1Kg 101101201 6 0 224 0 2 ed 7 Basmati GUARD Bagged Pakistan 5Kg 101101202 6 2 46 2 365 2 53 3 Basmati KHANGAR Khimgis Bagged Pakistan 20Kg 101101203 6 7 03 6 175 DE oTHer RICE 1011013 HO Unde Ben s Rice PLAST BAG U S A 2Kg 101101301 6 1 382 1 28 c i Egyptian Rice PLAST BAG EGYPIT 2Kg 101101302 4 0 513 0 475 0 52 4 af Basmati Sun White Bagged Australia 2Kg 101101303 6 0 649 0 604 0 695 0 869 OO riour 101102 LO a Brown Flour NO 2 Atta PAPER BAG OMAN FLRMILL SKg 10110201 6 0 797 0 79 0 805 0 981 mE HI Plain Flour All Purpose Flour Paper Bag Dahabi O 10110202 6 0 309 0 285 0 325 0 877 i Brown Flour NO 1 Maida Plst Bag OMANFLRMILL SKg 10110203 6 0 896 0 862 0 925 0 932 2 G pasta 101103 fl al Vermicelli Pasta PLS PAPER KOLSON U A E 450 g 10110301 8 0 168 0 155 0 175 aes Hr 4f Vermicelli Pasta Al Khaleejia U A E 453g 10110302 6 0 16 0 13 0 178 ar 12 i J Vermicelli Pasta PLS PAPER SIPA France 453g 10110303 6 0 184 0 171 0 195 5 G macaroni 101104 i iO Macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 6 0 137 0 125 0 15
20. 8 80 DC2 101101102 15 64 DC3 1021502 0 27 DC2 101418101 0 81 DC2 101311703 0 44 DC1 10123202 1 30 DC3 1023602 0 26 DC3 101611101 0 50 DC4 1019401 0 93 DC2 450603 1 69 DC3 910902 1 35 DC3 450103 0 49 DC2 10142103 1 46 DC2 101105202 0 14 DC3 101611102 0 55 DC2 2009 04 01 10222401 1 74 DC3 Record 1 of 3264 w w lt 282322232322323222323233333 G 5 Figure 4 1 16 1 Select Date Filter ee Peete ym iy loko Download data entr te v Invalid Observations Hc aa RR E TAILORING CHARGE Click here to add a new ro 0 41 0 62 Dc3 om 1 0 EDUCATIONAL SERVICES aa a 1 65 0 00 002 OMR 1 0 15 40 15 40 002 OMR 1 0 1 89 1 89 DC3 OMR 1 0 13 325002 0 30 0 37 DC3 OMR 1 0 8 80 8 80 DC2 OMR 1 0 2009 0401 101101102 13 58 20 00 1 12 51 15 64 DC3 OMR 1 0 2009 04 01 1021502 12 56 49 00 2 0 22 0 27 002 OMR 1 0 2009 0401 101418101 12 56 226 00 2 0 65 0 81 DC2 OMR 1 0 2009 0401 101311208 ii 1 1 00 1 0 44 0 44 DC1 OMR 1 0 2009 0401 10123202 13 103 454 00 2 1 04 1 30 DC3 OMR 1 0 2009 04 01 1023602 11 119 340 00 2 0 21 0 26 DC3 OMR 1 0 2009 0401 101611101 14 13 1001 0 50 0 50 DC4 OMR 1 0 2009 04 01 1019401 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 2009 04 01 450603 13 58 750 00 5 1 35 1 69 DC3 OMR 1 0 2009 04 01 910902 13 58 100 51 1 35 1 35 DC3 OMR 1 0
21. File Name To date Cancel EX Rejected Observations Observations Obs D Outlet C Obs Obs UoM C Obs P Conv Price Collector Curre Currency Exchange R Comm x 2009 12 19 TGFESEESHI vij OMR 1 2009 040 ProductCode Product Name I2 2 00 1 0 41 0 62 DC3 OMR 1 0 2009 040 isis d erai E 100 4 1 65 0 00 DC2 OMR 1 0 2009 04 0 101101103 Basmati Al Jabal 1 00 4 15 40 15 40 DC2 OMR 1 0 2009 04 0 1 00 4 1 89 1 89 DC3 OMR 1 0 101101202 Basmati GUARD 2009 040 151101203 Basmati KHANGA 325 00 2 0 30 0 37 DC3 OMR 1 0 2009 04 08 101101301 Unde Ben s Rice 1 00 4 8 80 8 80 DC2 OMR 1 0 2009 04 04 3 ai 20 00 1 12 51 15 64 DC3 OMR 1 0 2009 04 0 49 00 2 0 22 0 27 DC2 OMR 1 0 2009 04 01 101418101 12 56 226 00 2 0 65 0 81 DC2 OMR 1 0 2009 04 01 101311703 i1 1 100 1 0 44 0 44 DC1 OMR 1 0 2009 04 01 10123202 13 103 454 00 2 1 04 1 30 DC3 OMR 1 0 2009 04 01 1023602 1 119 340 00 2 0 21 0 26 DC3 OMR 1 0 2009 04 01 101611101 14 13 100 1 0 50 0 50 DC4 OMR 1 0 2009 04 01 1019401 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 2009 04 01 450603 13 58 750 00 5 1 35 1 69 DC3 OMR 1 0 2009 04 01 910902 13 58 1 00 51 1 35 1 35 DC3 OMR 1 0 2009 04 01 450103 12 56 450 00 2 0 39 0 49 DC2 OMR 1 0 2009 04 01 10142103 12 66 30 00 4 1 15 1 46 DC2 OMR 1 0 2009 04 01 101105202 13 58 400 00 4 0 11 0 14 DC3 OMR 1 0 2009 04 01 101611102 12 11 1 00 1 0 55 0 55 DC2 OMR 1
22. Get Data Import File Name To date 2009 12 16 Ea Cancel Export Observations Obs Date Product Code Location Code Outlet Code Obs Qty Obs UoMCode ObsPrice Conv Price Price Cs 2009 04 01 10111101 13 57 v 2 00 1 0 41 0 62 DC3 ts its 002 2009 04 01 241202 12 111 1 00 4 15 40 15 40 DC2 2009 04 01 451001 13 57 1 00 4 1 89 1 89 DC3 2009 04 01 211301 12 94 1 00 4 8 80 8 80 DC2 2009 04 01 101101102 13 58 20 00 1 12 51 15 64 DC3 2009 04 01 1021502 12 56 49 00 2 0 22 0 27 DC2 2009 04 01 101418101 12 56 226 00 2 0 65 0 81 DC2 2009 04 01 101311703 11 1 1 00 1 0 44 0 44 DC1 Outlet Code empty 61 101 13 1 00 1 0 50 0 50 DC4 66 150 00 2 0 74 0 93 DC2 m 2009 04 01 450603 13 58 750 00 5 1 35 1 69 DC3 m 2009 04 01 910902 13 58 1 00 51 1 35 1 35 DC3 m 2009 04 01 450103 12 56 450 00 2 0 39 0 49 DC2 m 2009 04 01 10142103 12 66 30 00 4 1 15 1 46 DC2 m 2009 04 01 101105202 13 58 400 00 4 0 11 0 14 DC3 m 2009 04 01 101611102 12 11 1 00 1 0 55 0 55 DC2 m 2009 04 01 10222401 13 57 400 00 2 1 39 1 74 DC3 Record 1 of 1632 gt Figure 4 1 9 1 Observation Data Import Error in Tooltip 5 1 10 Correct Invalid Observations After the import or save invalid observations system will show error and highlight all the invalid observations as shown in the figure 4 1 8 7 Now you can correct these invalid observations by following either of the two methods mentioned below
23. Observations Foreign Currency Obs Obs UoM C ObsP Conv Price Collector N Curre Currency Exchange R Comm Exchange Rate 20 Apply Foreign Currency gt Local Currency Master List From Region Import Master Data Export Master Data Change Database C NikhillProject ICP_Round2 Development bd Create New Database Figure 4 1 23 3 Save change Change Default Database t will display a message as shown below and Data entry application will be refreshed with the data available in the newly selected database Success Figure 4 1 23 4 Database changed Message Change Default Database 5 1 24 Create an empty Database Using this feature you can create an empty SQLite database which will be similar to the database which comes with the installation of the Household Price Collection software So after using the Household Collection software for one Country if you want to use it for another country you don t need to re install it You just need to create a new database and connect to it Section 4 1 23 Now you can setup the Survey Data for the new country by following the steps mentioned in Section 4 1 2 To create an empty database follow steps as mentioned below Launch the Data entry Application Page 44 of 73 gt Navigate to the Survey Setup screen by clicking on the Setup button gt Click on the button which is available next to the Cre
24. Price Collector N Qure Currency Exchange Comm a Record Dof0 Figure 4 1 8 1 Import Observations using Data Entry Template ud Open WH Jp Personal ICP v 4 f Search Organize ss Views Bi New Folder Date modified i test 12 16 2009 9 40 AM Data Entry XLS 12 7 2008 5 43 PM vorite Links Documents jj Recently Changed Ej Recent Places Data Entry Apr2009 XLS 12 1 2008 3 06 PM Desktop Data Entry Feb XLS 12 1 2009 9 57 AM Computer OMN HHC RawPrices 20010301 20091210 v XLS 12 11 2009 12 21 OM OMN HHC RawPrices 20081008 20091209 12 XLS 12 9 2009 2 11 PM OMN HHC RawPrices 20090127 20091204 vv XLS 12 7 2009 2 13 PM HHC RawPrices 20090609 20091215 v12 XLS 12 15 2009 12 58 BH OMN_HHC_RawPrices 20091002 20091202 5656 XLS 12 3 2009 6 05 PM Public OMN HHC RawPrices 20091002 20091202 bnb XLS 12 2 20094 10PM OMN HHC RawPrices 20091003 20091203 03 XLS 12 3 2009 5 05 PM HHC RawPrices 20091007 20091207 v XLS 12 7 2009 5 41 PM HHC RawPrices 20001007 20001207 vvv XLS 12 7 2009 5 42 PM Folders I LL File name Data Entry Template XLS Excel Files CALS A Open v Cancel Music Searches Figure 4 1 8 2 Select Data Entry Template File for Import Select the Data Entry Template file in which you have entered the observations Click Open System will start the import process by first vali
25. To set Deviation Limit change the value provided in the Deviation Limit field If the Deviation for an observation is invalid then its Deviation cell will be highlighted with the color shown in the Color selection box that is available next to the Deviation Limit text field Refer figure 4 2 7 4 for details Each time you modify this value you need to click on the Validate Average button to refresh the highlighting The rule for deciding invalid Deviation is If Deviation for an Observation is less than 1 Deviation Limit set in the Deviation Limit If Deviation for an Observation is greater than 1 Deviation Limit Formula for calculating Deviation Deviation Converted Price Average Price Average price 100 Page 58 of 73 5 2 9 Set T Ratio Limit To set T Ratio Limit change the value provided in the T Ratio Limit field If the T Ratio for an observation is invalid then its T Ratiocell will be highlighted with the color shown in the Color selection box that is available next to the T Ratio Limit text field Refer figure 4 2 7 4 for details Each time you modify this value you need to click on the Validate Average button to refresh the highlighting gt Therule for deciding invalid T Ratio is If T Ratiofor an Observation is greater than T Ratio Limit Set in the T Ratio Limit field gt Formula for calculating T Ratio T Ratio Converted Price Ave
26. Tode 20091216 E La J Export Click here to view selected filters E Rejected Obs Observations Obs D Product C Location C Outlet Obs Obs UoMC Obs P Conv Price Collector N Curre Currency Exchange R Comm 10111101 6 57 2 00 1 0 41 0 62 DC3 OMR 1 0 2009 04 01 101101102 12 318 1 00 4 1 65 0 00 DC2 OMR 1 0 2009 04 01 241202 12 111 1 00 4 15 40 15 40 DC2 OMR 1 0 2009 04 01 451001 13 57 1 00 4 1 89 1 89 DC3 OMR 1 0 2009 04 01 1023603 13 103 325 00 2 0 30 0 37 DC3 OMR 1 0 2009 04 01 211301 12 94 1 00 4 8 80 8 80 DC2 OMR 1 0 2009 04 01 101101102 13 58 20 00 1 12 51 15 64 DC3 OMR 1 0 2009 04 01 1021502 12 56 49 00 2 0 22 0 27 DC2 OMR 1 0 2009 04 01 101418101 12 56 226 00 2 0 65 0 81 DC2 OMR 1 0 2009 04 01 101311703 i1 1 1 00 1 0 44 0 44 DC1 OMR 1 0 2009 04 01 10123202 13 103 454 00 2 1 04 1 30 DC3 OMR 1 0 2009 04 01 1023602 1 119 340 00 2 0 21 0 26 DC3 OMR 1 0 2009 04 01 101611101 14 13 100 1 0 50 0 50 DC4 OMR 1 0 2009 04 01 1019401 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 2009 04 01 450603 13 58 750 00 5 1 35 1 69 DC3 OMR 1 0 2009 04 01 910902 13 58 1 00 51 1 35 1 35 DC3 OMR 1 0 2009 04 01 450103 12 56 450 00 2 0 39 0 49 DC2 OMR 1 0 2009 04 01 10142103 12 66 30 00 4 1 15 1 46 DC2 OMR 1 0 2009 04 01 101105202 13 58 400 00 4 0 11 0 14 DC3 OMR 1 0 2009 04 01 101611102 12 1 1 00 1 0 55 0 55 DC2 OMR 1 0 Figure 4
27. a rejected observation in the Observations grid is customizable You can select any color that is available in the Rejected Observations color box as shown in the screenshot below As soon as you select a new color all rejected observations will be highlighted with the selected color The application persist this change Page 61 of 73 6 Data Validation and Averaging Oman CTRY_HHC_DB 9 Dec s3db e save E save amp Print Print 6 o Ext 5 ichange Database Products File Name Location Location Type Click here to view selected filters f I Outlet Outlet Type A Export MinMax Price Ratio Limit Var Coefficient Limit Tvalue Limit 1 v ETE Products Observations Quotations Rejected ProductCode Product Name Location Code Location Name Location Type Obs Date Obs Qty Obs UoM Code obs UoM Obs Price L4 Basic Heading BASMATI INDIAN 101101101 Basmati TILDA Bagged Indian 5Kg 12 Bawshar Market 31 1 2009 01 01 Kiogram s Emus E p 77 CREE 101101101 Basmati TILDA Bagged Indian SKg 13 As Seeb 1 Market 32 1 2009 02 01 Kiogram s 101101101 Basmati TILDA Bagged Indian SKg 13 As Seeb 1 53 Market 33 1 2009 02 01 51 Kiogram s 101101101 Basmati TILDA Bagged Indian SKg 13 As Seeb 1 58 Market 33 1 2009 03 01 51 Kiogram s 101101101 Basmati TILDA Bagged Indian S
28. color box as shown in the screenshot below As soon as you select a new color all invalid observations will be highlighted with the selected color The application persist this change Page 41 of 73 ud Data Entry Oman CTRY_ HHC_DB s3db Products v Fromdate 2009 02 26 E Get Data Import Data Entry Mode File Name v Todate 2009 12 17 55 Cancel Export Click here to view selected filters Observations Obs D Product C Location C Outet C Obs Obs UoM C Obs P Conv Price Collector N Curre Currency Exchange R 2009 04 01 10111101 13 57 2 00 1 0 41 0 62 DC3 OMR 1 0 2009 04 01 101101102 12 1 65 0 00 DC2 2009 04 01 211301 2009 04 01 101418101 8 80 DC2 226 00 2 0 81 DC2 m 2009 04 01 10123202 NN RN 2009 04 01 101611101 2009 04 01 1019401 2009 04 01 450603 2009 04 01 910902 2009 04 01 450103 2009 04 01 10142103 2009 04 01 101105202 2009 04 01 101611102 2009 04 01 10222401 2009 04 01 441001 2009 04 01 10222303 2009 04 01 10110202 4 Record 9 of 3261 re m 13 454 00 2 1 30 0 m 14 1 00 1 0 50 DC4 1 0 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 13 58 750 00 5 1 35 1 69 DC3 OMR 1 0 13 58 1 00 51 1 35 1 35 DC3 OMR 1 0 12 56 450 00 2 0 39 0 49 DC2 OMR 1 0 12 66 30 00 4 1 15 1 46 DC2 OMR 1 0 13 58 400 00 4 0 11 0 14 063 OMR 1 0 12 11 1 00 1 0 5
29. its own format and that data will be transferred into the Region Page 8 of 73 4 Software Installation Please follow the steps as mentioned below to install the Household Price Collection module of the ICP Country software 1 Uninstall previous version of the software if it was installed 2 To begin the installation click on the ICP 2011 HHC Modules exe which will launch the screen shown below 5 Setup ICP 2011 HHC Modules Welcome to the ICP 2011 HHC Modules Setup Wizard This will install ICP 2011 HHC Modules 1 0 on your computer It is recommended that you close all other applications before continuing Click Next to continue or Cancel to exit Setup 3 Click on the Next button 4 Select the Folder Directory where you want to install this software by clicking on the Browse and then click Next Page 9 of 73 jBl Setup ICP 2011 HHC Modules Select Destination Location Where should ICP 2011 HHC Modules be installed A will install ICP 2011 HHC Modules into the following folder To continue click Next F you would like to select a different folder click Browse Lasers wb353626 Documents ICP 2011 HHC Modules At least 33 6 MB of free disk space is required 5 Leave the Create a desktop icon checkbox check to get the shortcut of the software on your desktop and then click Next HHC Modules Which additional tasks should be performed Select the addi
30. m Macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 9 m Sphagatti Long PAPER BOX HONIG HOLLAND SO 0g 10110402 9 m B Macaroni Cut PAPER BOX HONIG HOLLAND 50 Og 10110403 9 AM LEBANON BREAD 1011051 Figure 4 2 7 1 Select Products for Observation Details Click on the Observations Quotations Tab as shown in the figure below Data Validation and Averaging Oman 9 Dec s3db Products File Name From Date 2008 10 18 C Indude validated observations Get Location Location Type To Date 2009 12 18 Click here to view selected filters Outlet Outlet Type Averaging Method Arithmetic Mean MinMax Price Ratio Limit 0 6 E Var Coefficient Limit 5 Tolerance Ratio Limit 0 6 EE TValue Limit 1 Products f Observations Quotations Product Name gt E I IBASMATI INDIAN Basmati TILDA Bagged Indian 5Kg 101101101 Mf Basmati Maqbool BAGGED INDIAN 20Kg 101101102 9 m i XL MP Basmati Al Jabal Al Akhdar India 45Kg 101101103 12 E BASMATI PAKISTANI 1011012 LJ Basmati BOX PAKISTANI 1Kg 101101201 9 Min Max Price Ratio Product Code No of Price Quotati Basmati GUARD Bagged Pakistan 5Kg 101101202 9 Basmati KHANGAR Khimais Bagged Pakistan 20Kg 101101203 8 O 1 omer rice 1011013 Uncle Ben s Rice PLAS
31. the application features will be disabled Once you complete the Survey Data Setup all other feature of the application will be enabled Page 15 of 73 a HHC Data Entry CTRY HHC D8 s3db B Boece 8 8 Country Currency E Local Currency ES Foreign Currency Exchange Rate Change Database C W hi Project iCP Round2 Development Create New Database 44 4 Record OofO Figure 5 1 2 1 Data Entry Survey Setup screen gt Click on the Import Master Data button in the Survey Setup screen It will display a file selection screen as shown below a Open m QUO k Personal ICP 4 Search 1 Organize Views ie New Folder E Date modified E Data Entry Feb XLS 12 1 2009 9 57 AM HHC RawPrices 20010301 20091210 v XLS 12 11 2009 12 21 B OMN HHC RawPrices 20081009 20091209 12 XLS 12 9 2000211PM Recent Places EE OMN HHC RawPrices 20090127 20091204 vv XLS 12 7 2009 2 13 PM Desktop BE OMN HHC RawPrices 20090609 20001215 v12 XLS 12 15 2009 12 58 Computer BE OMN RawPrices 20091002 20091202 5656 XLS 12 3 2009 6 05 PIV Favorite Links E Documents jj Recently Changed Te Ba OMN HHC RawPrices 20091002 20091202 bnb XLS 12 2 2009 4 10 PIV HHC RawPrices 20091003 20091203 03 XLS 12 3 2009 5 05 PM RawPrices 20091007 20091207 v XLS 12 7 2009 5 41 PM HHC RawPrices 20091007
32. 0 w XLS More Control Panel EH OMN HHC RawPrices 20081009 20091209 12 XL al E l Recycle Bin OMN_HHC_RawPrices_20090127_20091204_ww XL di Personal RawPrices 20090609 20091215 v12 X di Code ES OMN_HHC_RawPrices_20091002_20091202_5656 di ICP RawPrices 20091002 20091202 bnb m test ES OMN_HHC_RawPrices_20091003_20091203_03 XL m Lease m Save as type Excel Files XL5 Hide Folders Figure 4 1 18 3 Select Export file Directory Exporting Observations Clicking on Save will start the export process and will display wait message as shown below Page 38 of 73 Fi Loading Data Please Wait Exporting Data Entry Records po 3075 Figure 4 1 18 4 Wait Message Exporting Observations gt On successful export it will display the message as shown below and Observations will Figure 4 1 18 5 Export Completed Message Exporting Observations 5 1 19 Modify existing observations using the exported Excel file In Section 4 1 18 we have seen how to download existing observations in an excel file This excel file can now be used for review and modification of existing observation data as well as addition of new observations New Observations can be added in the first empty row at the end of the Observations list It s not required to provide data in Name columns i e Product Name Location Name Outlet Name etc You just need to provid
33. 009 01 01 201 Kilogram s 2 49 2 0 286 136 As Seeb 1 58 Market 33 1 2009 01 01 201 Kilogram s 6 175 6 175 0 735 0 513 Bawshar 1 56 Market 31 1 2009 02 01 201 Kilogram s 11 19 11 19 1331 0 641 As Seeb 1 58 Market 33 1 2009 02 01 201 Kilogram s 11 3 11 3 1344 0 666 AsSeeb 1 57 Market 32 1 2009 02 01 201 Kilogram s 10 765 10 765 1281 0 543 As Seeb 1 58 Market 33 1 2009 03 01 201 Kilogram s 11 375 11 375 1353 0 683 As Seeb 1 57 Market 32 1 2009 03 01 201 Kilogram s 10 836 10 836 1289 0 559 Bawshar 1 56 Market 31 1 2009 03 01 201 Kilogram s 11 264 11 264 134 0 658 AsSeeb 1 57 Market 32 1 2009 01 01 11 Kilogram s 0 325 0 096 AsSeeb 1 58 Market 33 1 2009 01 01 11 Kilogram s 0 895 2951 2 617 Bawshar 1 56 Market 31 1 2009 01 01 11 Kilogram s 0 165 0 165 0 544 0 612 z ran EET Em em mm S j Figu re 4 2 10 1 Save Observation 5 2 11 Save Validated Observations You can Validate and modify observations by following the steps mentioned in section 4 2 10 After that clicking on the Save button will mark all selected observation shown in the Observation Quotation grid as validated If the Include Validated Observations was not checked the observation list will be cleared out shows blank observation grid Next time when you load the Observation summary for products these validated observation will not be shown unless you check the Include Validated Observations checkbox 5 2 12 Reject Observation
34. 009 0401 1023602 n 119 340 00 2 0 21 0 26 DC3 OR 1 0 2009 0401 1161102 4 13 1 00 1 0 50 0 50 DC4 OMR 1 0 299 0401 109401 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 0090401 450603 B 53 750 00 5 1 35 169 DC3 OMR 1 0 2009 0401 910902 5 58 1 00 51 1 35 1 35 03 OMR 1 0 2009 0401 450103 2 56 450 00 2 0 39 049 DC2 OMR 1 0 2009 0401 14033 2 66 30 00 4 115 146 DC2 OMR 1 a 2009 0401 01022 15 58 411 09 4 0 11 0 14 003 OMR 1 0 20090401 131612002 12 u 1001 0 55 0 55 DC2 OR 1 0 20090401 1022203 15 57 4 00 2 13 174 DC3 OMR 1 0 209 0401 441001 5 57 1004 0 15 0 15 DC3 OMR 1 0 20090401 10223033 3 57 100 00 2 LB 1 41 DC3 OMR 1 0 2009 0401 10100202 1 57 151 0 31 0 41 DC3 OMR 1 0 2009 0401 10122509 12 12 1 00 1 0 51 0 51 DC2 OR 1 o Figure 4 1 17 2 Delete Observations gt System will display a confirmation message as shown below Page 36 of 73 Figure 4 1 17 3 Delete Observations Confirmation Message gt Clicking on Yes will delete all selected observations and Observations Grid will be refreshed gt Clicking on no will not do anything and focus will return to the Observations grid 5 1 18 Export Existing Observations in an Excel file As described in section 4 1 12 and 4 1 13 the Data entry screen can show data in two formats Data Entry mode and Detailed View Mode similarly it also supports downloading a Blank Template Section 4 1 7 and downloading existing observatio
35. 01101 Basmati TILDA Bagged Indian 5Kg 13 As Seeb 1 58 Market 33 1 2009 01 01 51 Kilogram s 101101101 Basmati TILDA Bagged Indian 5Kg 12 Bawshar 1 56 Market 31 1 2009 01 01 51 Kilogram s 1 101101101 Basmati TILDA Bagged Indian SKg 12 Bawshar 1 56 Market 31 i 2009 02 01 51 Kilogram s 101101101 Basmati TILDA Bagged Indian 5Kg 13 As Seeb 1 57 Market 32 1 2009 02 01 51 Kilogram s 3 101101101 Basmati TILDA Bagged Indian SKg 13 As Seeb 1 Market 33 1 2009 02 01 Kilogram s Bos Se CENE T EN CNN NF RN 209041 NENNEN NN 101101101 Basmati TILDA Bagged Indian SKg 13 As Seeb 1 Market 32 1 2009 03 01 Kilogram s 101101101 Basmati TILDA Bagged Indian 5Kg 12 Bawshar 1 56 Market 31 1 2009 03 01 5 1 Kilogram s 3 KIKK Record 7 of 9 gt J m lt G Figure 4 1 14 1 Change Invalid Observations color 5 2 15 Change the Default Database If you have more than one database files Household Price Collection software database file available you can use any of those file in the Data entry application by changing its default database To Change the database follow the steps as mentioned below gt Launch the Data Validation and Averaging Application Onthe Main screen check the Change Database Checkbox as shown below It will Display a text filed and a button next to it The text field will show the full path of the database that is being used by the application Page 63 of 73
36. 1 0 50 0 50 DC4 OMR 1 0 2009 04 01 1019401 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 2009 04 01 450603 13 58 750 00 5 1 35 1 69 DC3 OMR 1 0 2009 04 01 910902 13 58 1 00 51 1 35 1 35 DC3 OMR 1 0 2009 04 01 450103 12 56 450 00 2 0 39 0 49 DC2 OMR 1 0 2009 04 01 10142103 12 u 30 00 4 1 15 1 46 DC2 OMR 1 0 2009 04 01 101105202 13 58 400 00 4 0 11 0 14 DC3 OMR 1 0 2009 04 01 101611102 12 11 1 00 1 0 55 0 55 DC2 OMR 1 0 2009 04 01 10222400 13 57 400 00 2 1 39 1 74 DC3 OMR 1 0 Page 37 of 73 Figure 4 1 18 1 Exporting Observation gt It will display a small screen dialog box asking for the file Name Enter the desired file name which you want to give to the Exported Excel File and click Ok to continue or Cancel to go back to the data entry main screen Export File Name File Name Figure 4 1 18 2 Export File Name Exporting Observation After Clicking Ok will it will display File Save dialog box which will display the formatted file name name provided you prefix with Country Code HHC RawPrices from date and To date Here you can also select the folder in which you want to export this Excel file Now Click Save to export the file al Save As Ba k 4 Ko Views Y F Mew Folder Faworite Links Name Ji test E Documents Data Entry XLS Data Entry Template XLS Folders Data Entry Apr2009 XLS Computer Data Entry Feb XLS E Network ES OMN RawPrices 20010301 2009121
37. 1 13 1 Entering new Observation Data Entry 5 1 14 View existing Observations You can view the existing observations by loading them in the Observations grid To load the observations follow the steps as mentioned below gt On the data entry screen select appropriate filter criteria such as From Date and To date both are mandatory then Products and file Names both are optional gt Click on the Get Data button gt It will display a wait message box as shown below 7 Loading Data Please Wait Loading Observations 16 Figure 4 1 14 1 Loading Observation Message Page 32 of 73 gt Grid will be loaded with all observations that match the filter criteria If there is no observation present in the database which matches with the filter criteria then a message will be displayed to the user as shown below i No matching record found for selected filters Figure 4 1 14 2 No matching Observation Message 5 1 15 Modify Observations via screen gt Load the existing observations which you want to modify by following the steps mentioned in section 4 1 12 gt Navigate to each of the observation which you wish to modify and make the necessary changes e g modify outlet code or Observed price etc Click on Save button Follow the steps mentioned in section 4 1 11 5 1 16 Filter Observations There are four filter criteria available on the main screen of the Data Entry application which
38. 1101102 Basmati Magbool SAGGED INDIAN 20Kg 13 As Seeb 1 58 Maket33 1 2003 02 01 21 Kiogram s m 101101102 Basmati Maqbool BAGGED NDIAN 20K9 13 As Seed 1 57 Maket32 1 2009 02 01 21 Kilograms 101101102 BasmatiMaqbool SAGGED INDIAN 20Kg 13 As Seed 1 58 Maket33 1 2009 03 01 21 Kiogram s m 101101102 BasmatiMadboo BAGGED INDIAN 20Kg 13 As Seed 1 57 Maket32 1 2009 03 01 1 Klogram s 101101102 Basmati Madboo BAGGED INDIAN 20Kg 12 Bawshar 1 56 Market31 1 2009 03 01 21 Kiogram s lad Basic Heading BASMATI PAKISTANI 101101201 Basmati BOX PAKISTANL IKg 13 As Seed 1 57 Market32 1 2009 01 01 11 Klogram s 101101201 Basmati 80X PAKISTANL IKg 13 5 1 sa Maket33 1 2009 01 01 11 Klogram s 101101201 Basmati BOX PAKISTANI IXp 12 Bawshar 1 56 Market31 1 2009 01 01 11 Kilogram s 101101201 Basmati BOX PAKISTANL Xg 13 Seeb 1 sa Maket33 1 2009 02 01 11 Klogram s 101101201 Basmati BOX PAKISTANI Xg 13 Seeb 1 57 1 2009 0241 11 Klogram s 101101201 Basmati BOX PAKISTANI Kg 12 Bawsher 1 56 Merket31 1 2009 02 01 11 Kiogram s lad 101101201 Basmati BOX PAKISTANI KG 2 Bawshar 1 56 Maket31 1 2009 03 01 11 Kiogram s m jt oa a a S Bl Figure 4 2 7 3 View Observation Details gt Deviation and T Ratio for an observation will be highlighted with different color if they are not valid as per the values set in the Deviation Limit and T Ratio fields as shown in the
39. 5 0 55 DC2 OMR 1 0 13 57 400 00 2 1 39 1 74 DC3 OMR 1 0 13 57 1 00 4 0 15 0 15 DC3 OMR 1 0 13 57 100 00 2 1 13 1 41 DC3 OMR 1 0 57 1 50 1 0 31 0 41 DC3 OMR 1 0 Download data entry templa E Invalid Observations Custom Y Web System Tes Figure 4 1 22 1 Change Invalid Observations color 5 1 23 Change the Default Database If you have more than one database files Household Price Collection software database file available you can use any of those file in the Data entry application by changing its default database To Change the database follow the steps as mentioned below Launch the Data entry Application Navigate to the Survey Setup screen by clicking on the Setup button gt Click on the button which is available next to the Change Database field Page 42 of 73 E E ee ei B m HHC Data Entry Oman CTRY_HHC DB _ 3 m 3 r dnjes Download data entr late Country Currency 11 08 m Data Entry Mode v Invalid Observations Local Currency 01 08 Export Click here to view selected filters EE v Rejected Observations Foreign Currency Exchange Rate 20 Apply Foreign Currency Local Currency 7 Price Collector N Master List From Region Import Master Data Export Master Data Change Database C WikhillProject CP Round2 Development Create New Database Figure 4 1 23 1 Chang
40. 59 0 al As Seeb 1 58 Market 33 1 2009 02 01 0 541 0 As Seeb 1 58 Market 33 1 2009 03 01 0 541 0 As Seeb 1 57 Market 32 1 2009 03 01 0 382 0 Bawshar 1 56 Market 31 1 2009 03 01 0 423 0 Bawshar 1 56 Market 31 1 2009 01 01 c 5 j 0 03 1 877 0 As Seeb 1 57 Market 32 1 2009 01 01 21 Kilogram s 2 49 D 0 296 1 361 As Seed 1 58 Market 33 1 2009 01 01 201 Kilogram s 6 175 6 175 0 735 0 513 0 Bawshar 1 56 Market 31 1 2009 02 01 201 Kilogram s 11 19 11 19 1 331 0 641 0 As Seeb 1 58 Market 33 1 2009 02 01 20 1 Kilogram s 11 3 11 3 1 344 0 666 0 As Seeb 1 57 Market 32 1 2009 02 01 21 Kilogram s 10 765 10 765 1 281 0 543 0 As Seed 1 58 Market 33 1 2009 03 01 201 Kilogram s 11 375 11 375 1 353 0 683 0 As Seed 1 57 Market 32 1 2009 03 01 2 1 Kilogram s 10 836 10 836 1 289 0 559 0 m Bawshar 1 56 Market 31 1 2009 03 01 20 1 Kilogram s 11 264 11 264 1 34 0 658 0 m As Seeb 1 57 Market 32 1 2009 01 01 11 Kilogram s 0 325 0 096 0 As Seeb 1 58 Market 33 1 2009 01 01 11 Kilogram s 0 895 2 617 0 m Bawshar 1 56 Market 31 1 2009 01 01 11 Kilogram s 0 165 0 612 0 FI As Seeb 1 58 Market 33 1 2009 02 01 111 Kilogram s 0 2 0 457 ou m As Seeb 1 57 Market 32 1 2009 02 01 1 1 Kilogram s 0 231 0 32 0 m Rawehar 1 SA Markat 31 1 nnqo n n1t 1 1 V deer amf el n amp A 235 n Page 59 of 73 Figure 4 2 10 1 Modifying an Observation gt Click on Save button Data Validation and A 89 Print
41. 621101 14 13 1 00 1 0 51 0 50 DX OMR 1 0 2009 04 01 1019401 12 6 0 00 2 0 7 0 93 DC OMR 1 0 2009 0401 450603 13 8 750 00 5 L3 OMR 1 0 2009 0401 910902 13 8 100 51 1 x OMR 1 0 2009 04 01 450103 2 56 450 00 2 0 39 0 49 DC2 OMR 1 0 2009 0401 10142103 12 amp 6 30 00 4 1 15 146552 OMR 1 0 20090401 101105202 13 58 400 00 4 0 11 0 14 DC3 OMR 1 0 2090401 101611002 12 m 1001 0 55 0 55 DC2 OMR 1 0 209 0401 1022201 13 57 400 00 2 139 174 DC3 OMR 1 0 2009 04 01 441001 13 57 1004 0 15 0 15 DC3 OMR 1 0 20090401 1022203 13 57 100 00 2 1 13 1 41 DC3 OMR 1 0 20090421 10110200 13 57 1 50 1 0 31 0 41 DC3 OMR 1 0 onne na n1 103171311 12 1 n Figure 4 1 16 3 Select File Name Filter Example Suppose you want to see all the observations available between two specific dates then select those two dates as From and to date and click on Get Data Now if you want to download Observations for specific products then select those products from the Products dropdown tree and Click on the Get Data button 5 1 17 Delete existing Observations You can delete single or multiple observations at a time through the Observations grid Follow the steps mentioned below to delete Observations Load Observations by following the steps mentioned in Section 4 1 14 or 4 1 16 Select the Observation that you want to delete by clicking on the row header of the Grid If you want to delete multiple observations hold t
42. 8202 13 E 400 00 4 0 11 0 14 DC3 ome 1 9 x 2009 0401 101611302 12 11 Loo 1 1 55 0 55 DC2 ONR 1 0 2009041 10222409 13 57 400 00 2 1 38 1 74 DC3 ONR 1 9 2009 04 01 441001 3 57 1504 0 15 9 15 DC3 ONR 1 0 2009 0401 10222033 3 5 100 00 2 1 13 L41 DC3 ONR 1 9 2009 04 01 10110202 3 5 190 1 0 31 0 41 DC3 ONR 1 9 2009 04 01 10171303 2 12 155 1 5 51 0 51 DC2 ONR 1 0 2009 04 01 1020103 13 58 20900 2 0 42 0 53 DC3 CHR 1 9 2009 04 01 1023903 13 5 85 00 5 0 08 0 11 063 CHR 1 9 2009 04 01 10181202 2 500 00 2 0 36 0 45 DC2 ONR 1 o 2009 04 01 910601 12 56 125 00 2 0 65 0 81 DC2 ONR 1 9 2009 04 01 10151902 12 11 LOO 0 20 0 20 DC2 ONR 1 9 5 m Record tof 3264 P Figure 4 1 17 1 Select multiple observations Delete gt Click onthe Delete button that is available on the Data entry screen Todate 2009 016 D Cancel Export Click here to view selected fiters V Rejected Obser OutletC Obs Obs UoMC ObsP Conv Price Colector N Cure Currency Exchange R Comm 10111101 57 2001 0 41 0 62 DC3 OMR 1 o 101101102 318 1 00 4 1 65 0 00 DC2 OMR 1 a 57 1 00 4 1 89 199 DC3 OR 1 0 94 1004 8 80 8 80 DC2 OMR 1 0 eae 101101102 v 20 00 1 12 5 64 DC3 OMR 0 1021502 2 56 49 00 2 0 22 0 27 DC2 OMR 1 0 101418101 12 56 226 00 2 0 65 0 81 DC2 OR 1 o 10131703 11 1 1 00 1 0 44 0 44 DCI 1 o 2009 0401 1012222 13 103 45400 2 104 130 DC3 OMR 1 0 2
43. 9 pe2 OMR 1 o 7 Gram s 198 00 2 Gram s 0 08 0 10 Dc3 OMR 1 0 Millilitre s 200 00 5 Millilitre s 0 08 0 10 DC3 OMR 1 0 Gram s 195 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 Gram s 198 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 71 Milllitre 5 200 00 5 Millilitre s 0 08 0 10 3 OMR 1 m Gram s 195 00 2 Gram s 0 08 0 10 DC3 OMR 1 0 5 BEG Record 3 of 3261 EEE L Figure 4 1 20 1 Change Rejected Status 5 1 21 Change the row highlighting color of the rejected observations The back color of a rejected observation in the Observations grid is customizable You can select any color that is available in the Rejected Observations color box as shown in the screenshot below As soon as you select a new color all rejected observations will be highlighted with the selected color The application persist this change Page 40 of 73 Data Entry Oman CTRY_HHC_DB s3db VLLL ULL V M Download data entry templa Products v Fromdate 2009 02 22 E Get Data Import Data Entry Mode Invalid Observations File Name v Tedate 2009 12 17 5 Cancel Export Click here to view selected filters II Rejected Observations com web stem Observations HE B NN ps EE SESE Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 m Gram s 70 00 2 Gram s 0 06 0 08 DC3 OMR 1 0 m Gram s 70 00 2 Gram s 0 06 0 08 DC2 OMR 1 0 Gram s 28 00 2 Gram s 0 06 0 08 DC3 OMR
44. AR Knimgis Bagged Pakistan 20Kg 101101203 6 JCB OTHER RICE 1011013 i _ a Uncle Ben s Kice PLASI BAG U S A ZKC 1U11U13U1 5 aT Egyptian Rice PLAST BAG ESYFIT 2Kg 1011013C2 4 LO MP Basmal Sun While Bauged Asslialia 2K 101101303 6 OA Lour 101102 Brown Four NO 2 Att2 PAPER EAG OMAN FLRMILL SKg 10110201 6 LI MP Plain Flour All Pursoza Flour Paper Bag DaFabi O 10110202 i LEN MP Rravm Four NO 1 Maida Plst RMTIT SKg 10110207 6 LIB Pasta 101103 HD IF Vermicelli 2asza PLS PAPER KOLSON U A E 450 q 10110301 8 HD IP Vernicelli 2as a Al lt haleejia U A E 453g 10110302 6 E If Vermicelli 28 8 5 PAPER SIPA France 453g 1011030 6 SOB 101104 LC macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 6 SE Sphagati Long PAPER EOX HONIG HCLLAND SO 2g 10110402 6 if gl Macaroni Cut PAPER BOX HONIG HOLLAND 50 Og 10110402 6 E f EBANON BREAD 1011051 i If Lebanon Bread NO Name 3piece 101105101 8 HL Lebanon Bread Large NO NAME 3piece 1011051C2 6 ett eee Figure 4 2 4 1 Validate and Average Observations gt The system will calculate MinMax Price ratio Average Price and Var Coefficient for all products for which there exists at least one Observation While calculating these values system will display wait message as shown below f Loading Data Please Wait Validating and Averag
45. B 2009 04 01 450103 12 56 450 00 2 0 39 0 49 002 OMR 1 0 2009 04 01 1014200 12 66 30 00 4 115 1 46 002 OMR 1 0 2009 0401 101105202 13 58 400 00 4 0 11 0 14 DC3 OMR 1 0 2009 0401 101611102 12 11 1 00 1 0 55 0 55 DC2 OMR 1 0 2009 04 01 10222401 13 7 400 00 2 1 39 174 DC3 OMR 1 0 v 4 Record 1 of 3264 gt m om gt Figure 4 1 16 2 Select Products Filter Page 34 of 73 Data Entry Oman CTRY_HHC_DB s3db dnas Q y 7 y J eo oT 2 r1 pe ect Download data eni Get Data Import 5 Data Entry Mode B Invalid Observe Na Non Cancel Export Click here to view selected filters E v Rejected Obsen Obs D ObsP Com Price Colector N Curre Currency Exchange R Comm a BENE 0 41 9621565 wR 1 0 2009 04 01 101101002 12 1 1 00 4 1 0 00 D OMR 1 0 2009 04 01 241202 1 111 1 00 4 15 40 15 40 DC2 OMR 1 0 2009 0401 451001 1 57 1004 189 89 DC OMR 1 0 2009 0401 1023603 13 103 325 00 0 30 0 37 DC OMR 1 0 2009 04 01 211301 1 54 1 00 4 8 80 8 80 DC OR 1 0 2009 0401 101101102 13 58 20 00 1 12 51 15 64 DC OMR 1 0 2009 0401 1021502 12 6 49 00 0 22 0 27 Dx OMR 1 o 2090401 101418101 12 56 226 00 2 0 65 0 81 DC2 OMR 1 0 2090401 113333 11 1 1001 0 44 0 44 DI OMR 1 0 2009 0401 10123202 13 103 454 00 2 1 04 1 30 DC3 OMR 1 0 2009 0401 1023602 1 119 340 00 0 21 0 26 DC OMR 1 0 2009 0441 101
46. BC Driver J SQUXML 30 4 Back Figure 5 1 1 2 Data Entry Option in the Start Menu Setup Survey Setup Import Data Initial Setup After Launching the Data Entry Application first time it is very important to set up the Survey data without which both Data Entry as well Data Validation and Averaging application cannot be used Each country office will receive a master list in the form of an Excel sheet which will contain seven worksheet each of which is described below 1 Country Details This is a read only worksheet which will have following details pre filled for the Country e Country Code Three digit code for the country e Country Name Name of the Country e Description Additional Details if any Page 14 of 73 e Local Currency Official Local currency National currency of the Country e Foreign Currency Secondary Currency that is being used in the country if there is any 2 Product Mater This is also a read only worksheet which will have list of all products for which the country is suppose to collect the price data 3 Location Type This worksheet will be pre filled with list of Location types You can modify all the details of a location type except the Location Type Code You can also add a new Location type in the first empty row that is available at the end of this list 4 Location Type This worksheet will be pre filled with list of Location types You can modify all the details of a location type ex
47. Documents dida eH jj Recently Changed Xx Recent Places Desktop Computer Pictures Music Searches Public Folders File name CTRY DB s3db Figure 4 2 15 2 Select Database file Change Default Database Page 64 of 73 gt The full path of the new database will be populated in the Change database text field gt Now click on Save to connect to this database EN Data Validation and Avcraging Oman CTRY HHC DB 9 Dccs3db 18 Mo dule um Change Database w Print l Help Exit M fe WikhiliPro ect ICP Round2 Development P ndi ct v File Name From Nate 2nna 1n 17 a L1 Indude vaidated observations Get Data Locaton iv Location Type v To Date 2009 12 17 dick here to view selected filters Cutlet v Outlet Tyre vi Averaging Method rit metc Mean v Export MinMax Price Ratio Limit 0 6 E v Var Coefficiert Limit 5 Ez 5 Tolerance Ratio Linit C 6 Tvalue Limit 1 Es mmm Products Observations Quotations Product Name Product Code No of Price Quotations Average Prize Mir Price Max Frice Mn Max Price Ratio Var Coefficient Figure 4 2 15 3 Save change Change Default Database gt It will display a message as shown below and Data application will be refreshed with the data available in the newly selected database Success Figu
48. Kg 13 As Seeb 1 57 Market 32 1 2009 03 01 51 Kgogram s B 101101101 Basmati TILDA Bagged Indian SKg 12 Bawshar 1 56 Market 31 1 2009 03 01 51 Kiogram s 3 record ore DAI r 5 Figure 4 2 13 1 Change Rejected Observations color 5 2 14 Change the row highlighting color of the invalid observations Similar to Rejected Observations the back color of Invalid observations in the Observations grid is customizable You can select any color that is available in the Invalid Observations color box as shown in the screenshot below As soon as you select a new color all invalid observations will be highlighted with the selected color The application persist this change Page 62 of 73 Data Validation and Averaging Oman CTRY_HHC_DB 9 Dec s3db cj save amp Print B Hp E v Invalid Observations E v Rejected Observations change Database custom web System Products File Name Location Location Type Click here to view selected filters Y EEUU E e l Validate Average Outlet Outlet Type eee Export J MinMax Price Ratio Limit Var Coefficient Limit TValue Limit 1 E v enis Products Observations Quotations Rejected Product Code Product Name Location Code Location Name Location Type Wyer LOGE Name ER Type Obs Date Obs Qty Obs UoM Code Obs UoM Obs Price Z Basic Heading BASMATI INDIAN 1011
49. L UE Recycle Bin EH OMN HHC RawPrices 20090127 20091204 wv XL J Personal EP OMN RawPrices 20090609 20091215 v12 X JH Cede BF OMN HHC RawPrices 20091002 20091202 5656 di ICP EF OMN HHC RawPrices 20091002 20091202 bnb d test EH OMN HHC RawPrices 20091003 20091203 03 XL Lease d sn d File name ion Hide Folders Save Figure 4 1 3 2 Survey Setup Data Export file name gt Data Export will start and system will display Wait Dialog along with a progress bar as shown below More Loading Data Please Wait Exporting Products Figure 4 1 3 3 Page 19 of 73 Survey Setup Data Export Progress gt Once the Export is completed system will display Exported Successfully message as shown below Figure 4 1 3 4 Survey Setup Data Export Completed 5 1 4 Add Locations and Outlets Process of adding locations and outlets during the initial setup is already described in Point 7 of Section 4 1 2 After the initial setup if you want to add new locations or outlets or both then export the Survey Setup Data in an Excel file steps mentioned in section 4 1 3 and then add new Location and outlet details in the Location Outlets worksheet of this Excel and save Now Import this excel file by following the steps mentioned in section 4 1 2 5 1 5 Modify Add Survey Setup Data Process of adding or modifying the Survey Setup Data Location type Outlet Type UoM and UoM co
50. MinMax Price Ratio Min Price Converted Price Max Price Converted Price 3 343 11 122 13 098 0 224 2 46 7 03 1 382 0 513 0 649 0 797 0 309 0 896 0 168 0 16 0 184 0 137 0 323 0 335 0 098 0 242 0 1 0 3 0 097 3 075 10 765 12 502 0 2 2 365 6 175 1 28 0 475 0 604 0 79 0 285 0 862 0 155 0 13 0 171 0 125 0 294 0 295 0 09 0 225 0 1 0 3 0 09 13 75 0 909 2 537 0 932 0 525 0 905 0 805 0 981 0 925 0 932 0 25 0 9 0 1 1 0 3 1 Page 53 of 73 8 954 2 308 3 977 7 785 3 047 8 478 6 17 4 878 5 805 0 857 6 043 2 858 5 292 12 123 5 871 8 235 7 178 4 748 5 342 0 5 342 Data Validation and Averaging Oman CTRY_HHC_DB 9 Dec s3db Change Database ul amp Print I8 Help bi C Nikhil Project ICP_Round2 Developmeni m Products File Name From Date 2009 01 27 Indude validated observations Location v Location Type v To Date 2009 12 17 Click here to view selected filters Outlet Outlet Type Averaging Method arithmetic Mean 5 MinMax Price Ratio Limit 0 9 Var Coefficient Limit 5 Tolerance Ratio Limit 0 6 v TValue Limit 1 Ev iie Products Observations Quotations Product Name Product Code No of Price Quotati Average Price Min Price Max Price Min Max Price Ratio Var Coefficient A BASMATI INDIAN Basmati TILDA Bagged Indian 5Kg 101101101 6
51. Pls Bottel DRUMMER U K 750ml 13 As Seeb 58 Market33 1 Urban _ 2009 04 01 910902 Baby Napkins Super AL Jamil 17 Pades Medium Red 4 10k Oman 13 As Seeb 58 Market 33 1 Urban m 2009 04 01 450103 Powder Detergent Extra TIDE Box S Arabia 450g 12 Bawshar 56 Market 31 1 Urban 2009 04 01 10142103 Fresh Eggs Medium Ahmaed Nasser Farm Barka OMAN 30eggs 12 Bawshar 66 Market40 1 Urban 2009 04 01 101105202 Small Bread Sliced amp White NO Name 400Pack 13 As Seeb 58 Market33 1 Urban m 2009 04 01 101611102 Green Apple U S A 1Kg 12 Bawshar 1 Market6 1 Urban 2009 04 0 iss 4 13 As Seeb 57 Market 32 1 Urban ogg miren Figure 4 1 12 2 Empty row in Detailed View Data Entry To add new observations follow the steps as mentioned below Navigate to the first row empty row in the Observations grid Navigate to each column by either using mouse or Tab button Enter data in all columns e g observation date product code location code etc VV ON ON WV All master data column such as Product Code Name Location Code Name and Outlet Code Name etc shows a prefilled list of available codes and names on mouse click You can either pick the code from these lists or enter it using the keyboard Page 30 of 73 a Data Entry Oman CTRY_HHC_DB s3db 1 5 1 8 dns J Delete e Help Ext Products From date Invalid Observations
52. T BAG U S A 2Kg 101101301 9 m Egyptian Rice PLAST BAG EGYPIT 2Kg 101101302 6 E Basmati Sun White Bagged Australia 2Kg 101101303 9 2 OG roug 101102 m Brovn Flour NO 2 Atta PAPER BAG OMAN FLRMILL SKg 10110201 9 m E Plain Flour All Purpose Flour Paper Bag Dahabi O 10110202 9 imi Brown Flour NO 1 Maida Plst Bag OMANFLRMILL SKg 10110203 9 OB pasta 101103 m Vermicelli Pasta PLS PAPER KOLSON U A E 450 g 10110301 12 m 0 Vermicelli Pasta Al Khaleejia U A E 453g 10110302 9 m 5 Vermicelli Pasta PLS PAPER SIPA France 453g 10110303 8 Jng macaroni 101104 m D H AMP Macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 9 m Sphagatti Long PAPER BOX HONIG HOLLAND SO 0g 10110402 9 m Macaroni Cut PAPER BOX HONIG HOLLAND 5O 0g 10110403 9 CI f LEBANON BREAD 1011051 Figure 4 2 7 2 Navigate to Observation Details gt The Observation Details will be displayed in a grid as shown below Page 56 of 73 Data Vabdaton and Averaging Oman CT ed ree O ex HB invalid Observations Rejected Observations C Change Database Products File Name From Date wet Hem tuo ume Click here to view selected fiters imas Validate Average Outlet Outet Type Averaging Method FF are Export MirMax Price Ratio Limit Ver Coefficient Limit ca Tolerance Ratio Limit 0 6 EE v Tvae Limit 1
53. You can select one or multiple or none All products for which you want to load View the observations summary Page 49 of 73 on the screen If you don t select any product then this filter criterion will be ignored and observations summary for all products will be loaded Locations This field shows a list of all available Locations in the form of a drop down list You can select one or multiple or none All Locations for which you want to load View the observations summary on the screen If you don t select any location then this filter criterion will be ignored and observations summary for all locations will be loaded Outlets This field shows a list of all available Outlets in the form of a drop down list You can select one or multiple or none All Outlets for which you want to load View the observations summary on the screen If you don t select any Outlet then this filter criterion will be ignored and observations summary for all Outlets will be loaded File Name This field shows list of all file name to which you have exported observations previously Export is described in Section 4 18 If you never exported observations before then it will display None in the list which means Empty file Name or observations which are not yet exported Location Type This field shows a list of all available Location Type in the form of a drop down list You can select one or multiple or none All Location Type for which you want to load Vi
54. ate New Database field uj HHC Data Entry Oman CTRY HHC DB s3db i B ose B we ie J Download data entr ate Country Currency Products v From date AISTE Get Data Import v Invalid Observations i Local Currency File Name v Tedate 2010 01 08 Cancel Export Rejected Observations 3e Foreign Currency Observations Obs D ProductC Location C outetc obs Obs UoM C ObsP Price Colector N Curre Currency Exchange Rate Apply Foreign Currency gt Local Currency Master List From Region Import Master Data Export Master Data Change Database C Nikhil Project ICP_Round2 Development ai Create New Database 4 Record0of0 i Figure 4 1 24 1 Create Empty database gt t will display a file save dialog box screen as shown below Select the Folder where you want to create the new database provide the Database File Name and Click on Save button Favorite Links E Documents F CTRY HHC DB s3db More Folders Computer Network Contral Panel Recycle Bin di Fersonal Ji Code Filename New DB s3db Save as type w Hide Folders Figure 4 1 24 2 New Database file Name and Location Create Empty database Page 45 of 73 Clicking on Save will populate the New Database name along with the folder path selected
55. ation creates a Shortcut along with an icon for the Data Validation and Averaging application on the desktop It also adds it under the Program Menu User can click on the shortcut or click on the Start Menu gt Programs All Programs in Vista gt ICP 2011 HHC Modules gt HHC Data Validate And Average Page 46 of 73 9 2 2 Figure 4 2 1 1 Data Validation and Averaging Shortcut on the Desktop Ls Microsoft Visual SourceSafe Microsoft Visual Studio 2005 4 amp Mozilla Firefox d Optional Applications Consumer Applications d Consumer Price Index System Data Processing Module by Developer Express v6 3 d Developer Express v2009 vol 1 d ICP 2011 HHC Modules 39 Uninstall HHC Modules Lotus Applications e Microsoft Framework SDK v2 0 Microsoft Office 4e Microsoft SQL Server 2005 Jk Microsoft Visual SourceSafe J amp Microsoft Visual Studio 2005 LD Mozilla Firefox d Optional Applications ib Remote Access 4 SAP amp BW SQLite ODBC Driver J SQLXML 30 4 Back Figure 4 2 1 2 Data Validation and Averaging Option in the Start Menu View Observation Summary for Products You can view the existing observations Summary for all products by loading them in the Products grid To load the Observation summary follow the steps as mentioned below On the Main screen of application select appropriate filter criteria such as From Date To date and Averaging Method All three are mandat
56. ations C Change Database From Date To Date Click here to view selected filters Validate Average vera Averaging Method Export Tolerance Ratio Limit 0 6 v TValue Limit 1 os v Cancel Rejected Product Code Product Name Location Code Location Name Location Type Outlet Code OutletName Outlet Type Obs Date Obs Qty Obs UoM Code Obs UoM Obs Price Basic Heading BASMATI INDIAN Basmati TILDA Bagged Indian SKg Basmati TILDA Bagged Indian SKg 12 Basmati TILDA Bagged Indian SKg 12 Basmati TILDA Bagged Indian SKg 13 Basmati TILDA Bagged Indian SKg 13 Basmati TILDA Bagged Indian SKg 13 Basmati TILDA Bagged Indian 5Kq 13 Basmati TILDA Bagged Indian SKg 12 Rejected 101101 101101101 101101101 101101101 101101101 101101101 LT 7 Is E JE Bawshar Bawshar As Seeb As Seeb As Seeb As Seeb Bawshar to 58 Maket33 2090101 Keogam 1 5 1 5 1 Kilogram s 1 1 56 Market 31 1 2009 01 01 51 Kilogram s 1 1 56 Market 31 1 2009 02 01 51 Kilogram s 1 57 Market 32 1 2009 02 01 51 Kilogram s 3 1 58 Market 33 1 2009 02 01 51 Kilogram s 1 58 Market 33 1 2008 03 01 51 Kilogram s 1 57 Market 32 1 2009 03 01 51 Kilogram s 1 56 Market 31 1 2009 03 01 51 Kilogram s 3 Figure 4 2 10 1 Reject Observation 5 2 13 Change the row highlighting color of the rejected observations The back color of
57. awshar 1 56 Market 31 1 2009 03 01 51 Kilogram s 3 633 3 633 0 678 9 423 0 Bawshar 1 56 Market 31 1 2009 01 01 20 1 Klogram s 0 25 2 0998 1 877 0 As Seeb 1 57 Market 32 1 2009 01 01 20 1 Kilogram s 2 49 0 256 1 361 AsSeeb 1 58 Market 33 1 2009 01 01 20 1 Kilogram s 6 175 6 175 0 735 9 513 ol Bawshar 1 56 Market 31 1 2009 02 01 20 1 Kilogram s 11 19 11 19 1331 0 641 0 AsSeeb 1 58 Market 33 1 2009 02 01 20 1 Kiogram s 11 3 11 3 1344 0 666 0 AsSeeb 1 57 Market32 1 2009 02 01 20 1 Kilogram s 10 765 10 765 1281 0 543 o AsSeeb 1 58 Market 33 1 2009 03 01 20 1 Kilogram s 11 375 11 375 1353 0 683 0 As Seeb 1 57 Market 32 1 2009 03 01 201 Kilogram s 10 836 10 836 1 289 0 559 0 Bawshar 1 56 Market 31 1 2009 03 01 20 1 Kilogram s 11 264 11 264 134 0 658 As Seeb 1 57 Market 32 1 2009 01 01 11 Kilogram s 0 325 0 325 1071 0 096 0 AsSeeb 1 58 Market33 1 2009 01 01 11 Kilogram s 0 895 0595 295 2617 Bawshar 1 56 Market31 1 2009 01 01 11 Klogram s 0 165 0 165 0 544 0 612 AsSeeb 1 58 Market 33 1 2009 02 01 11 Kilogram s 0 2 0 2 0 658 0 457 o AsSeeb 1 57 Market 32 1 2009 02 01 11 Kilogram s 0 231 0 231 0 762 9 32 0 Bawshar 1 56 Market 31 1 2009 02 01 11 Kiogram s 0 25 0 25 0 824 0 236 0 Bawshar 1 56 Market 31 1 2009 03 01 11 Kioaram s 0 225 0 225 0 742 9 347 om Figure 4 2 7 4 Invalid Deviation Limit and T Ratio Limit 5 2 8 Set Deviation Limit
58. bles you to group data against one or more columns If you group data by a column records with identical column values are arranged into corresponding data groups The group row can be expanded to access the underlying data rows Type E Priority E Name E Created Date E Owner E Project Name Enterprise Accounting System 5 Status New E Bug L Low Transaction History 3 27 12004 Carl Lucas Bug 4 Medium Installer 21112004 Bert Parkins l Status w Fixed l Project Mame Home Office Accounting System it Status New Status Fixed me Request j Low Accounting Systemi 7 1 2004 Jerry Campbell An end user can group data by a particular column by dragging its header from the column header panel or the customization form onto the group panel To ungroup the data remove the column header from the group panel by dragging it You can also change the order of the grouping columns using drag and drop It s also possible to group data by a column by selecting the Group By This Field option from the column header context menu To ungroup data use the Un Group option from the same menu or Clear Grouping from the group panel context menu Records are always sorted against the grouping columns If you group data against a column which isn t sorted the grid control will automatically apply sorting in ascending order to the column Subsequently if you remove the column from the group panel its sor
59. by you in the Create New Database text field Ga HHC Data Entry Oman HHC_DB s3db SS gt n Setup 5 A ET eed Survey Setup zn sis 9 ip uod Download data entry template Country Currency Products v From date 2009 11 08 E Get Data Import v Invalid Observations Local Currency File Name v Todate 2010 01 08 5 Cancel Export Rejected Observations 3e Foreign Currency Observations 5 Obs D Product C Location C Outlet C Obs Obs UoM C Obs P Conv Price Collector N Curre Currency Exchange Rate Apply Foreign Currency gt Local Currency Master List From Region Import Master Data Export Master Data Change Database C WikhillProject ICP_Round2 Development EA Create New Database C Nikhil Project ICP_Round2 Developmeni Cil l Create Record 0 of 0 i gt Figure 4 1 24 3 Create Empty database 8 ti H s gt Clicking on Create button will create an Empty database at the selected location and display the message as shown below Success Figure 4 1 24 4 New Database Created Message Create Empty database 5 2 Data Validation and Averaging Application 5 2 1 Launch the Data Validation and Averaging application After the installation The HHC Module on install
60. can be used for filtering the existing observations From Date Observation Date of the observation should not be before this date This is a mandatory filter criterion To Date Observation Date of the observation should not be after this date This is a mandatory filter criterion Products This field shows a list of all available products in the form of a tree You can select one or multiple or none All products for which you want to load View the observations on the screen If you don t select any product then these filter criteria will be ignored and observations for all products will be loaded File Name This field shows list of all file name to which you have exported observations previously Export is described in Section 4 1 18 If you never exported observations before then it will display None in the list which means Empty file Name or observations which are not yet exported gt Select Products from the Products dropdown tree Optional gt Select Exported File Name from the File Name drop down Optional Select From Date and To date Page 33 of 73 Data Entry Oman CTRY_HHC Loungi 313 Wasi Exp v Fromdate AIPA Data Entry Mode Wednesday December 16 2009 v To date February 2009 Click here to view selected filters Mon Tue Wed 27 3 10 10111101 3 17 0 62 DC3 101101102 24 0 00 DC2 241202 15 40 DC2 451001 1 89 DC3 1023603 0 37 DC3 211301
61. cept the Location Type Code You can also add a new Location type in the first empty row that is available at the end of this list 5 UoM Master This worksheet will be pre filled with list of Units of Measurement UoM You can modify all the details of a UoM except the UoM Code You can also add a new UoM in the first empty row that is available at the end of this list 6 UoM Conversion Factors This worksheet will be pre filled with Conversion factors for all available UoMs You can modify all the details of a UoM Conversion factors except the Source and Target UoM Codes You can also add new UoM conversion factors for newly added UoM in the first empty row that is available at the end of this list 7 Location Outlets The master list sent by the Region will not have any entry for the Locations and Outlets in this worksheet which means this will be sent as a blank list with only column headers You will have to add details of all the Locations in your country along with their corresponding outlets in this Excel sheet Once you make all the correction modification in the Master list save it Now to setup the Survey Data follow the steps mentioned below Launch the Data Entry application and click on the Setup button that is available on the top left corner of the screen Before the Survey Data Setup the screen will look like as shown below Note You will only be able to import Survey Setup data at this point of time and rest of
62. dating the data in the file and then importing and saving it in to its own database While import is in process a wait dialog along with a progress bar will be displayed Page 24 of 73 Loading Data Please Wait Initializing Import 10 Figure 4 1 8 3 Observation Data Import progress gt If there was no error in the data system will complete the import and Figure 4 1 8 4 Observation Data Import Completed gt Click on Save button to save all the imported records to the database gt n case the Excel file has invalid or incorrect data e g Invalid or empty product code Invalid foreign Currency etc Same record added twice in a worksheet System will display an error as shown below gt Ei zt ize Figure 4 1 8 5 Observation Data Import Error Message It will also display a Hyperlink View Error Details on the Top of the main screen Clicking on this Hyperlink will open an Excel file which will have details of all errors in the Master List data along with Work Sheet Name and Row Number All the observations which were present in the Data entry template will be loaded in the Data entry screen and invalid observations will be highlighted as shown in the figure 4 1 8 6 Page 25 of 73 dnos View error detas Donnioad data entry template Products wj Fromdste mss E Get Data met v Data Entry Mode iaid Observations Fie Name Todste 2009
63. e Default Database gt It will display a file Selection dialog box screen as shown below Locate the database file which you want to use in the Data Entry application and click on Open button ad Open P ds gt Personal j 3 c Organize Views v New Folder ICP test Name tW CTRY HHC DB s3db vorite Links E Documents 12 4 2009 1 51 PM j Recently Changed Xy Recent Places HH Desktop ji Computer E Pictures gm Music E Searches d Public Folders iB m P File name CTRY_HHC_DB s3db v SQLite Files 5348 Z Figure 4 1 23 2 Select Database file Change Default Database gt The full path of the new database will be populated in the Change database text field gt Nowclick on Save to connect to this database Page 43 of 73 ery eo 2 gt s a IL B t Entry Gp Survey Setup S O Download data entry template Country Currency 11 08 53 Get Data Import v Data Entry Mode IB v Invalid Observations Local Currency 01 08 Ez Cancel i Export Click here to view selected filters EE v Rejected
64. e Help o Ext E v Invalid Observations E v Rejected Observations Change Database Products File Name From Date Location Location Type To Date Click here to view selected filters noc Validate Outlet Outlet Type Averaging Method ES MinMax Price Ratio Limit Var Coefficient Limit Tolerance Ratio Limit 0 6 TValue Limit 1 v EE Products Observations Quotations Location Name Location Type Outlet Code Outlet Name Outlet Type Obs Date Obs Qty Obs UoM Code Obs UoM Obs Price Conv Price Tolerance Ratio T Value Comments Valida EE CICNNNNCCHNEECINNEENTINECO NNNM UN As Seeb 1 57 Market32 1 2009 01 01 51 Kilogram s 11 19 1 19 208 1 426 m Bawshar 1 56 Market 31 1 2009 01 01 51 Kilogram s 13 75 13 75 2 565 2 052 Bawshar 1 56 Market 31 1 2009 02 01 51 Kilogram s 3 25 3 25 0 606 0 516 AsSeeb 1 57 Market 32 1 2009 02 01 51 Kilogram s 3 075 3 075 0 574 0 559 AsSeeb 1 58 Market 33 1 2009 02 01 51 Kilogram s 3 15 3 15 0 588 0 541 AsSeeb 1 58 Market 33 1 2009 03 01 51 Kilogram s 3 15 3 15 0 588 0 541 asSeeb 1 57 Market 32 1 2009 03 01 51 Kilogram s 3 8 3 8 0 709 0 382 Bawshar 1 56 Market 31 1 2009 03 01 51 Kilogram s 3 633 3 633 0 678 0 423 Bawshar 1 56 Market 31 1 2009 01 01 20 1 Kilogram s 0 25 0 25 003 1 877 As Seeb 1 57 Market 32 1 2
65. e data in all mandatory columns and then save the Excel file Now you can import it to the system by following the steps as mentioned in section 4 1 9 and 4 1 11 5 1 20 Change the Rejected status of an Observation While validating existing observations using the Data Validation and Averaging application any observation can be marked as Rejected by the user The rejection could be based on certain rules guidelines which will be followed by the user who validates the Observations If an observation is rejected the Data Entry screen will display Rejected in the Rejected column of the Observations grid and will be highlighted with the color set selected in the Rejected Observations color selection box The Rejected Column can be seen only in the Detailed View Mode of the Observations grid To change the Rejected status observation follow the steps as mentioned below Navigate to the Rejected observation Click on the Rejected field A drop down will be shown with two options Rejected and empty Select empty Repeat these steps for all Rejected observations that you want to change Click on Save VVVVV V Page 39 of 73 IE Data Entry Oman CTRY_HHC_DB s3db dp i ij save 5 Delete 69 Preview Hep ex ata Entry MONT 7 Download data entry template Products v Fromdate 2009 02 22 1 Get Data Import 7 Data Entry Mode E Invalid Observations File Name
66. e format as the Master Data file sent by the regional office Steps for exporting the Survey Setup Data are mentioned below Page 18 of 73 gt Click on the Export Master Data button that is available on the Survey Setup screen AR vic Dam Enn Od CTRYHHC 83 OS 9 tom x m ta En A Survey Setup Country Currency 1108 amp Get Data Import 7 Data Entry Mode Invalid Observations Local Currency 01 08 E Cancel Export Click here to view selected filters Rejected Observations Obs Obs UMC ObsP Conv Price Colector N s Curre Currency Exchange R Comm Exchange Rate Master List From Region Change Database CENERE Project YO Round2 Development Create New Database Figure 4 1 3 1 Exporting Survey Setup Data Select the folder where you want to save the exported file provide the file name and click on Save aol Save As COO pm t Personal ICP Search P I ay Organize ss VIEWS New Folder E Faworite Links E Documents Data_Entry XLS Bx Data Entry Template XLS Folders Bx Data Entry Apr2009 XL5 JE Computer B Data Entry Feb XLS EP Network BE OMN HHC RawPrices 20010301 20091210 5 Control Panel EH OMN RawPrices 20081009 20091209 12 X
67. ed in section 4 1 20 3 Through main screen of the data entry application which is described later in section 4 1 14 For bulk data entry importing the observation using the Data entry Template file is the fastest method Following are the steps for this method Download a Data entry Template file Refer Section 4 1 7 gt Open the Excel file and enter data in all mandatory columns Optional columns can be left empty if you do not want to enter data explicitly If you already have observations in more than one excel file then you can either import each of those files one by one or copy all observations from those excel files into one file Data entry template and then import them together Please note that importing an Excel file with more than 2000 records might take more time slow Savethe Excel file and close it before importing gt Click on the Import button that is provided on the Main screen of the Data entry application System will show a file selection dialog box Page 23 of 73 Data Entry Oman CTRY HHC DB s3db IEP 2011 ea 1 Delete 9 Hp O ext Download data entry template Products W Fromdate 2009 10 16 Tol GetOsta E met 1 7 Data Entry Mode invald Observations Fie Name vi Todate 2009 12 16 Cancel Export Click here to view selected fiters E Rejected Observations Observabons ObsD ProductC Location Outlet Obs ObsUoMC ObsP Com
68. erating the Average prices This user manual describes following usage scenarios for both Data Entry and Data Validation amp Averaging application e Data Entry Application o Howto launch the Data Entry application o Howto Setup Import Survey Setup Data Initial Setup o Howto Add Locations and Outlets o How to Modify Add Survey Setup Data o Howto Export Survey Setup Data List o Howto Set Exchange Rate between Local Currency and Foreign Currency o Howto Download Data Entry Template o Howto import Observations o Howto view Import Errors o Howto Correct Invalid Observations o Howto Save Imported Observations o Howto Add New Observations via screen o Howto Change on screen Data entry mode o Howto Modify Observations via screen o Howto view existing Observations o Howto filters Observations o Howto View filters o Howto Delete existing Observations o Howto Export Existing Observations in an Excel file o Howto modify Existing Observations using the exported Excel file o Howto Change the Rejected status of an Observation o Howto Change the row highlighting color of the rejected observations o Howto Change the row highlighting color of the invalid observations Page 12 of 73 O O How to Change the Default Database How to Create an empty Database e Data Validation amp averaging Application O O O How to launch the Data Validation and Averaging application How to View filters How to filters Observations How to view Ob
69. escaunsecescauseeessaueecsssauasecessaunsesessaaasees 35 5 1 18 Export Existing Observations in an Excel file sss 37 5 1 19 Modify existing observations using the exported Excel file sese 39 5 1 20 Change the Rejected status Of an Observation assesses 39 5 1 21 Change the row highlighting color of the rejected observations seen 40 5 1 22 Change the row highlighting color of the invalid observations esee 41 5 1 23 Change the 6 42 5 1 24 Create an empty 44 DATA VALIDATION AND AVERAGING APPLICATION UnxsUuuE Sa EVEN EUR tute RETI FUEN D NK e SEE 46 5 2 1 Launch the Data Validation and Averaging application sees 46 5 2 2 View Observation Summary for Products csssssecccceessececcneeseccsnaeesecessaueecessaussecsssauseeessaees 47 5 2 3 Filter Observations Summary eeiissseeissseeee essen nennen nna nnns sa aane ssa asinus ases saa ness assa s aan 49 5 2 4 Validate and calculate Average Prices for Products
70. ew the observations summary on the screen If you don t select any location type then this filter criterion will be ignored and observations summary for all location types will be loaded Outlet Type This field shows a list of all available Outlet Type in the form of a drop down list You can select one or multiple or none All Outlet Type for which you want to load View the observations summary on the screen If you don t select any Outlet Type then this filter criterion will be ignored and observations summary for all Outlet Types will be loaded Select Products from the Products dropdown tree Optional Select Exported File Name from the File Name drop down Optional Select From Date and To date Include Validated Observations There is an Include Validate Observations checkbox available on the screen Checking this box and clicking Get Data will include already validated observations while calculating the average prices for each product that is loaded in the grid Please refer the screenshot below for all filter criteria on this screen Page 50 of 73 Data Validation and Averaging Oman CTRY_HHC_DB s3db 2009 10 17 _ Indude validated observations Get Data To Date 2009 12 17 sii Click here to view selected filters Outlet Type v Averaging Method Arithmetic Mean Export MinMax Price Ratio Limit 0 6 Em Var Coefficient Limit 5 v Tolerance Ratio Limit 0 6
71. figure below The color for highlighting these invalid values will be used as per the color shown next to the Deviation Limit and T Ratio Limit text fields Page 57 of 73 Data Validation and Averaging Oman CTRY HHC DB 9 Dec s3db Module 5 save E Print 9 Help i9 Exit Invalid Observations E Rejected Observations _ Change Database Products File Name From Date Location Location Type To Date Click here to view selected filters m Outlet Outlet Type Averaging Method MinMax Price Ratio Limit Var Coefficient Limit Tolerance Ratio Limit 4 0 6 v Tolerance Ratoune o6 Em Cmm aa Observations Quotations Location Name Location Type Outlet Code Outlet Name Outlet Type Obs Date Obs Qty Obs UoM Code Obs UoM Obs Price Conv Price Tolerance Ratio T Value Comments Validated 9 AsSeeb 1 58 Market 33 1 2009 01 01 51 Kilogram s 3 25 3 25 0 AsSeeb 1 57 Market 32 1 2009 01 01 51 Kilogram s 11 19 11 19 Bawshar 1 56 Market 31 1 2009 01 01 51 Kiogram s 13 75 13 75 0 Bawshar 1 Market 31 1 2009 02 01 Kilogram s 3 25 3 25 0 NE EMEN ER s NN RES As Seeb 1 Market 33 1 2009 02 01 Kilogram s 3 15 3 15 0 588 0 541 AsSeeb 1 58 Market 33 1 2009 03 01 51 Kilogram s 3 15 3 15 0 588 0 541 As Seeb 1 57 Market 32 1 2009 03 01 51 Kilogram s 3 8 3 8 0 709 0 382 B
72. he Shift key and one by one click on the row header of all the observations that you want to delete Page 35 of 73 e 8 cente amp Preview Heo ew Download data entry tempiate Products Long 313 Wes Exp v Fromdete 20090226 1 Z Dats Entry Mode idd Ooservstors Meheme None 1 2991 2 6 oo comm com Cho here 1 view selected fiers E Rejected Observatons Observatons omo Product Locstonc OufetC Obs Obs UMC ObeP Com Prce Colector Caren Exchange R Comm Ael 2009 04 01 10111101 13 0 62 DC3 ao090401 102201202 12 0 00 DC2 2009 04 01 451001 13 57 1504 1 89 1 89 DC3 ONR 1 o 2009 04 01 211301 12 94 1004 8 80 8 80 DC2 ONR 1 9 NN NENNEN GNE 2009 04 01 1021502 12 4540 2 0 22 0 27 DC2 ONR 1 9 2009 04 01 101418101 2 t 226 00 2 0 65 0 81 DC2 ONR 1 o 2009 04 01 10131103 i 1 1 00 1 0 44 0 44 DC1 ONR 1 9 2009 04 01 10123202 13 103 454 00 2 104 1 30 063 CHR 1 9 2009 04 01 1023602 it 119 340 00 2 0 21 0 26 DC3 ONR 1 0 2009 04 01 101611300 4 13 100 1 0 50 0 50 DC4 ONR 1 9 2009 04 01 1019401 2 6 190 00 2 0 74 0 93 DC2 ONR 1 9 2009 04 01 450603 n 58 750 00 5 1 35 1 69 DC3 ONA 1 0 2009 04 01 910902 3 s 100 51 1 35 135 DCS ONR 1 9 m 2009 04 01 450103 2 E 450 00 2 0 38 0 49 DC2 ONR 1 0 2009 04 01 10142103 12 66 3000 4 115 1 46 DC2 OWA 1 9 2009 04 01 10110
73. ing 16 Figure 4 2 4 2 Wait Message Validate and Average Observations After calculating all the above mentioned values it will populate them for all listed products as shown below Page 52 of 73 Outlet MinMax Price Ratio Limit 0 9 v Products Observations Quotations 2009 01 27 2009 12 17 Arithmetic Mean File Name From Date Location Type v To Date Outlet Type Averaging Method Var Coefficient Limit 5 Tolerance Ratio Limit Change Database C ikhil Project ICP_Round2 Developmeni v C Indude validated observations Click here to view selected filters TValue Limit 1 y Min Max Price Ratio i a Basmati TILDA Bagged Indian 5Kg 101101101 6 A MP Basmati Maqbool BAGGED INDIAN 20Kg 101101102 d x MP Basmati Al Jabal Al Akhdar India 45Kg 101101103 8 m CL PAKISTANI 1011012 L Basmati BOX PAKISTANI 1Kg 101101201 6 O Basmati GUARD Bagged Pakistan 5Kg 101101202 Basmati KHANGAR Khimgis Bagged Pakistan 20Kg 101101203 6 GOB OTHER RICE 1011013 LO Uncle Ben s Rice PLAST BAG U S A 2Kg 101101301 6 E Egyptian Rice PLAST BAG EGYPIT 2Kg 101101302 4 8 Basmati Sun White Bagged Australia 2Kg 101101303 6 GOB 101102 Brown Flour NO 2 Atta PAPER BAG OMAN FLRMILL SKg 10110201 6 5 Plain Flour All Purpose Flour Paper Bag Dahabi O
74. ing Multiple Rows For selecting multiple rows at a time do one of following 1 Click on the row header and hold CTRL button and click on the next row you want to select 2 Click on the row header and hold Shift button and click on the next row you want to select 6 2 Tree Control This control has been used in some of the popup in both applications and Quotation Observation summary list in the Data Validation and Averaging module Page 71 of 73 6 2 1 Resizing Nodes and Columns The following mouse operations can be performed by end users to resize columns and nodes Action Dragging a column header s right edge Dragging an indicator cell s bottom edge Double clicking a column header s right edge Double clicking an indicator cell s bottom edge Selecting the Best Fit Best Fit all columns item from the column header s context menu 6 2 20 Controlling the Visibility of Columns Effect Changes the column s width Changes the node s height Changes the column s width to best fit its content Applies auto height to all nodes Applies best fit to the corresponding column or all columns The following mouse operations allow end users to change the visibility of columns The Customization Form can be opened by Selecting Column Chooser from the header panel context menu Action Selecting the Runtime Column Customization item from the context menu Dragging a column header onto the customi
75. just above the Import Master Data button Clicking on this Hyperlink will open an Excel file which will have details of all errors in the Master List data along with Work Sheet Name and Row Number Page 17 of 73 dd HHC Data Entry CTRY HHC DB 5348 Currency Local Currency Foreign Currency Exchange Rate Foreign Currency gt Local Currency Master List From Region ITIN Change Database C Nikhil ProjectiI O _Round2 Development Create New Database Record 0ofO Figure 4 1 2 6 Survey Setup Data Import Error Hyperlink Master List Import Errors 20091216124916 xls Mic 3 Home Insert Pagelayout Formulas Data Review View Developer Macros Cut cali E E p sa ste F Format Pante 18 LUi AA E S EE EE Mergea center 8 si Condoni E E E Clipboard Fy Font Alignment p Number p Styles Al Errors Listed on 12 16 2009 12 49 17 PM 2 WorkSheet_Name ROW_NUMBER Error_Text 3 Location Type 5 Location Type Code or Location Type Name is empty 4 Outlet Type 4 Duplicate Outlet Type 3 Outlet Type 5 Duplicate Outlet Type 6 UoM Master 12 Duplicate UoM Code 7 UoM Master 13 Duplicate UoM Code 3 10 1 0 Figure 4 1 2 7 Survey Setup Data Import Error Hyperlink 5 1 3 Export Survey Setup Data The Survey Setup data can be exported to an Excel file The Exported Excel file will have the sam
76. l ae alt aaa pe 69 6 1 3 ete i 70 6 1 4 FUIGING Ubused COIms sse iot id dius thc Int oett etd Ded ti o tci epa tc doa tede ttn 71 6 1 5 Selecting MUNDE ROWS esidnsedted ty Ner rebum ases 71 6 2 ide pilos m 71 6 2 1 RESIZING NOGES and COIUImmis sesta ticdu iae nta 72 6 2 2 Controlling the Visibility of Columns eee eene eene nnne nnn annees naar ns 72 6 2 3 Reordaerimg Columns ang NODES od io e d b e ca d ea d lp 72 6 2 4 SOTUN O wmv tine EE ae 73 Page 3 of 73 1 Introduction The ICP Country Software is a part of the International Comparison Program which includes a series of statistical surveys held worldwide to collect price data for a sample of commonly bought goods and services This document is mainly focused towards the Household Price Collection module of the ICP Country software The ICP Household Price Collection module is divided into two sub modules e Data Entry e Data Validation and Averaging 1 1 About this Guide This guide acts as a reference manual for the User and features the following sections e Installation e Feature Overview e User Guide 1 2 Scope The scope of this document at present covers only installation process and features of the Household Price Collection Module of the ICP Country software 1 3 Definitions and Acronyms Following are the definitions and abbreviations used in this d
77. lf Yearly or Quarterly or Monthly based on the selection in previous screen Selected Time period i e H1 H2 or Q1 Q2 etc then year entered by you to return to the main screen Page 67 of 73 CS oJ Save As HHC DataEntry bin Database 4 Search 7 Wi Organize EE owe BR New Folder Favorite Links l Mo items match your search E Documents More Folders ii HHC di Database di Demo Database di HHE Components HHC_DataEntry HHC_DataEntry W bin di Databas Hide Folders Figure 4 2 16 2 Export Average Prices and Observations Save gt Clicking on Save will start the export process and display the wait message as shown below Loading Data Please Wait Exporting end di Figure 4 2 16 3 Export Average Prices and Observations Wait message gt On successful completion of Export it will display message as shown below and Observations will be downloaded in the Excel file which will be downloaded at the selected location Figure 4 2 16 4 Export Average Prices and Observations completed Page 68 of 73 6 Common control features This section describes important features of some of the UI controls that has been used in the ICP Country software 6 1 Grid Control This control has been used in both Data entry and Data Validation and Averaging modules for displaying the observations 6 1 1 Grouping Rows Ena
78. micelli 2as a PLS PAPER SIPA France 453g 10110302 6 0 184 0 171 2 195 5 871 GOB MACARON 101104 Macaroni Cut PAPER BOX KOLSON U A E 400g 10110401 6 0 137 0 125 0 5 8 235 HL Kf Sphagati Long PAPER EOX HONIG HCLLAND SO 2g 10110402 6 0 323 0 294 3 345 Ps 7 178 7 uf Macaroni Cut PAPER BOX HONIG HOLLAND 50 0g 10110402 6 0 325 0 295 9 315 0 787 8 065 SOG EBANON BREAD 1011051 Lebanon Bread NO Name 3piece 1011051501 8 0 058 0 09 o 4 748 SE M Lebanon Bread Large NO NAME 3piece 101105102 6 0 242 0 225 0 25 0 9 5 342 i PO lahanan Orms ACMA IIMA MAME San ARA nt nat nat 1 n Figure 4 2 6 1 Set Variation Coefficient Limit 92 7 The observation details are shown in the Observations Quotation tab of the data grid which shows the Observation summary for products User can select more than one product at a time and view its details To view Observation Details for products follow the steps mentioned View Observation Details below gt Load the Observation Summary for products by following steps as mentioned in section 4 2 2 or 4 2 3 or 4 2 4 Select the product for which you want to see the observations details from the Observation Summary as shown in the figure below Page 55 of 73 i Data Validation and Averaging Oman CTRY HHC DB 9 Dec s3db change Database Products File Name From Date 2008 10 18 C Indude validated observations Get Loca
79. ng countries In practice a basic heading is defined as the lowest level of final expenditure in the GDP for which explicit expenditures can be estimated International Household Survey Network s IHSN software tools which provide features for storing survey questionnaires documentation on the surveys as well as survey responses data The IHSN Toolkit uses international standards called Data Documentation Initiative DDI for documenting the data Set of five or six choices that characterize an outlet where price observations are collected These can be Department Store Market Street Vendor etc These types could vary from region to region IHSN ToolKit Outlet Types Preferred The quantity that is set as the standard quantity Quantity by which a product s converted price is to be measured A product basket is defined in terms of the Products comprising the list taken along with their preferred measures and preferred quantities Preferred The UoM that is set as the standard measure by UOM which a product s converted price is to be measured A product basket is defined in terms of the Products comprising the list taken along with their preferred measures and preferred quantities Page 5 of 73 Previous This selection means that the reference price in Period the compare process is arrived at using the Price period prior to the selected period for fetching the reference set of observations 2 Sys
80. nly average prices for products then select Averages Only for exporting Observation details only select Detailed Observations Only or in case you want to export both in a single Excel file then select Both Page 66 of 73 Select export option below Averages only Detailed observations only Both Frequency Yearly Time Period File Name Figure 4 2 16 1 Export Average Prices and Observations Options Select frequency such as Yearly Half Yearly Quarterly or Monthly from the drop down shown in the figure 4 2 16 1 Select Time Period If you select Yearly frequency you can enter the year in the Time Period e g 2009 2008 etc If you select Half Yearly then the Time Period drop down will display H1 and H2 If you select Quarterly frequency then the Time Period drop will display Q1 Q2 03 and Q4 representing each quarter of the year If you select Monthly frequency the Time period drop down will display all twelve month of the year out of which you can select any one month In the File Name text field provide name which you want to give to the Exported Excel file Click OK to proceed with the Export or Cance without exporting data Clicking will display the file save dialog box as shown the figure below The file name provided by you in the previous screen will be pre fixed with Country Code HHC AveragePrices or RawPrices based on the selection in previous screen Yearly or ha
81. ns data in Detailed View mode To Download Existing Observations follow the steps as mentioned below Onthe data entry screen select appropriate filter criteria such as From Date and To date both are mandatory then Products and file Names both are optional gt Click on the Export button Download data entry templat Products 313 Wasi Exp j x Fromdate 20099226 Geta met Data Entry Mode v Invalid Observations File Name v Tedate 2009 12 16 5 Canai Click here to view selected filters E Rejected Observations Observations ObsD Product Location c outetc obs Obs uomc obsP Conv Price Colector N Curre Currency ExchangeR Comm 1 0 2009 04 01 101101102 12 318 100 4 1 65 0 00 DC2 OMR 1 0 2009 04 01 241202 12 111 1 00 4 15 40 15 40 DC2 OMR 1 0 2009 04 01 451001 13 57 1 00 4 1 89 1 89 DC3 OMR 1 0 2009 04 01 1023603 13 103 325 00 2 0 30 0 37 DC3 OMR 1 0 2009 04 01 211301 12 94 1 00 4 8 80 8 80 DC2 OMR 1 0 2009 0401 101101002 13 58 20 00 1 12 51 15 64 DC3 OMR 1 0 2009 04 01 1021502 12 56 49 00 2 0 22 0 27 DC2 OMR 1 0 2009 0401 101418101 12 56 226 00 2 0 65 0 81 DC2 OMR 1 0 2009 0401 101311703 11 1 1 00 1 0 44 0 44 DC1 OMR 1 0 2009 04 01 10123202 13 103 454 00 2 1 04 1 30 DC3 OMR 1 0 2009 04 01 1023602 n 119 340 00 2 0 21 0 26 DC3 OMR 1 0 2009 04 01 101611101 14 13 1 00
82. nversion Factors during the initial setup is already described in Point Section 4 1 2 But you want to add modify Survey setup Data after the initial setup is done then follow the steps as mentioned below gt Export the Survey Setup Data in an Excel file steps mentioned in section 4 1 3 Add new Records at the end of the worksheet or modify the existing records gt Save the Excel file gt Import this excel file by following the steps mentioned in section 4 1 2 5 1 6 Set Exchange Rate between Local Currency and Foreign Currency The Exchange Rate can be set only when Foreign Currency present for a Country The Exchange Rate is nothing but the conversion factor between the Local Currency and Foreign Currency Since the Exchange rate keeps on changing with time you can change it as and when required Once you set the value for Exchange Rate it will be used as the default Exchange rate for all future Data entry Observations for which Observed price is collected in foreign currency and Exchange is rate is not provided explicitly To Set the Exchange Rate follow the steps as mentioned below Page 20 of 73 gt Navigate to the Survey Setup screen gt Enter the Exchange in the Exchange Rate field gt Click on the Apply button a9 HHC Data Entry Oman CTRY HHC 08 348 n bje in 19 A if 2i Download data entry template Survey Setup E Coun Data Entry Mode invad Obse
83. oc ie SFR dEME EUER 20 5 15 Modi Add Survey Setup DOLO audies estes ases eset osea e quss AE NARA 20 5 1 6 Set Exchange Rate between Local Currency and 20 5 1 7 Download Data Entry Template cccccsssccccsescccnescccsussccssusecescusecsaanscssausesssausessausecesauasessaes 21 5 1 8 Import OOS CTV OU OE ONTO EEEE 23 5 1 9 I ET ON errata EE UM 26 5 1 10 Correct Invalid Observations eiiis eene enne nnne nnns saa annees aa aan ssa annes 27 5 41 11 Saveimpored denti vu ER oda dese addas 28 5 142 Add New Opservations VIG SCI ETsas tdi ss etie FLU EISE RH edis Edu Dade ios 29 5 1 13 Change on screen Data entry MOO i sia xcd kat S ERR E ERE Er ekUF Ex ATE XEM E SER o Eu RN R OK ec 32 5 1 14 View existing 32 5 1 15 Modify Observations via 5 6 33 6 VHterODSOervatiOnsesuseatetterim sm pert Rm UO RERUM Tt UR ERR UU E EHE RUNS 33 5 1 17 Delete existing Observations 0 scccccccsseeseccccneseeecccaussee
84. ocument International Comparison of Prices Price This is the price quoted by a vendor for a product quotation item as specified in the ICP product list The price quotation is basically the complete database record that includes information on the product the outlet shop where this product is priced the type of that outlet code the monthly price the variety description the geographic area code the month the price was collected and all other attributes such as rural urban domestic imported sale price regular price seasonal non seasonal etc Location These are attributes that classify the demography Types of the survey location for example Rural Urban High Mid Low Income etc The list of attributes would be configurable by the Region for their countries This is used to take multiple logical Page 4 of 73 views on the same physical Location hierarchy The physical nature of the Location hierarchy which remains the same across all the logical views is preserved by the parent child relationship Weights This refers to the purchasing power information that is captured at the elementary product level Ul User Interface UoM Unit of Measurent UOM PC Price Collector HHC Household Consumption Items Basic In principle basic heading consists of a group of Heading similar well defined products from which sample of products can be selected that are both representative of their types and purchases in participati
85. ons Geta at Location Location Type vj To Date 2009 12 17 E Click here to view selected filters perenn Outlet v Outlet Type v Averaging Method Arithmetic Mean v a Bpo MinMax Price Ratio Limit 0 9 E v Var Coefficient Limit 5 v Tolerance Ratio Limit 0 6 v TValue Limit 1 cance Products Observations Quotations Product Name Product Code No of Price Quotati Average Price Min Price Max Price Min Max Price Ratio Var Coefficient gt BASMATI INDIAN i LO Basmati TILDA Bagged Indian 5Kg 101101101 6 m MP Basmati Maqbool BAGGED INDIAN 20Kg 101101102 m LN MP Basmati Al Jabal Al Akhdar India 45Kg 101101103 8 BASMATI PAKISTANI 1011012 m Mf Basmati BOX PAKISTANI 1Kg 101101201 6 m Basmati GUARD Bagged Pakistan 5Kg 101101202 6 m LEN Basmati KHANGAR Khimgis Bagged Pakistan 20Kg 101101203 6 lO 1f oter RICE 1011013 m inf Uncle Ben s Rice PLAST BAG U S A 2Kg 101101301 rH 15 Egyptian Rice PLAST BAG EGYPIT 2Kg 101101302 4 rm E Basmati Sun White Bagged Australia 2Kg 101101303 1S COB roug 101102 m aMff Brown Flour NO 2 Atta PAPER BAG OMAN FLRMILL SKg 10110201 6 m MP Plain Flour All Purpose Flour Paper Bag Dahabi O 10110202 6 i Brown Flour NO 1 Maida Plst Bag OMANFLRMILL SKg 10110203 6 OL1f pasta 101103 i Vermicelli PastaJ PLS PAPER KOLSON U A E 450 g 10110301 8
86. orm to the View s client area Banded Views support the same operations with bands See the topic for details The Customization Form can be opened by Selecting Column Chooser from the header panel context menu To hide a specific column band an end user can do one of the following gt Drag acolumn band header onto the Customization Form gt Drag acolumn band header away from the Column Header Panel even if the Customization Form is not visible Right click a column header and select Remove This Column from the Column Header Context Menu Customization Drag 4 column header here to group by that column p Inf Contact Info esanal Info npud eee Work ome Calumns Bards Customer ID Contact Mame Company Mame Fax Country City Address TIERE Futterkiste 1230 00743 ANATA Ana Trujillo Ana Trujillo Empare 5 555 3 B 555 47 Mexico M xico Avda de la Lonstituc ANTON Antonio Morena Antonio Morena T a 5 555 383 Mexico M xico Mataderos 2312 AROUT Thamas Hardy Around the Horm 171 55 171 555 UK London 120 Hanover 5q BERGS Christina Berglund Berglunds snabbkop 0921 12 0921 12 3 Sweden Lule Benguvsvagen BLAUS Hanna Moos Blauer See Delikate 0621 08 0621 08460 Germany Mannh Forsterstr 57 After columns bands have been hidden they can be restored by opening the Customization Form and dragging them from the Customization form onto the Column Header Panel 6 1 5 Select
87. ory filters and all other are mandatory Click on the Get Data button Page 47 of 73 ug Data Validation and Averaging Oman CTRY_HHC_DB s3db l3 E Print 8 Help ext J Invaid Observations v Rejected Observations Change Database oe m je C Location f Location Type To Date Click here to view selected filters Outlet Outet Type Averaging Method Export MinMax Price Ratio Limit EE Var CoeffiGent Limit c Tolerance Ratio Limit A E TValue Limit 1 roms J cance Products Observations Quotations Rejected Product Gude Product Name ocaon Location Nas cation Outlet C OuletN Outlet Type Obe Date Obe Qty Obs Uo Obe uoM conven Trance Tk Mt 4 RecordOofO wx E a gt Figure 4 2 2 1 Load Observation Summary for Products gt It will display a wait message box as shown below Loading Data Please Wait Loading data 10 Figure 4 2 2 2 Loading data Message gt Grid will be loaded with all observations that match the filter criteria Refer the screenshot below Page 48 of 73 HE Data Validation and Averaging Oman CTRY_HHC_DB 9 Dec s3db Change Database e 9 emt Hp O ex C WihilProjectUCP Round2Ipevelopment Products v File Name v From Date 2009 01 27 E _ Indude validated observati
88. ploaded data will be stored into SQLite database o Observations will be entered uploaded into the data entry screen and observations will be stored into SQLite database Already saved master data will be used here to perform the basic validations in the screen like invalid product code etc and also user can select the master list lookup to pick an item from the list O Observations can be exported into excel sheet and manually imported into IHSN tool kit Page 7 of 73 e Data Validation and Averaging Module O Observations entered uploaded through the data entry module that are already stored in SQLite database will be used for validation and averaging observations This module will validate the observations and system will calculate amp display averages in the screen Validated observations can be saved and the data will be stored in SQLite database The average calculated data can be exported into excel in a predefined template Validated and averaged data can be exported into excel sheets and those are manually imported into IHSN toolkit e SQLite Database O Both modules share common SQLite database which is being used to store the data from the data entry and data validation amp averaging modules e HSN Toolkit O The exported excel sheet from data entry or data validation amp averaging module will be manually imported into IHSN toolkit IHSN toolkit internally stores the uploaded metadata and micro data into
89. rage Price Std Deviation 5 2 10 Modify Observation Details The Data Validation and Averaging Module allow modifying only following values for an observation e Observed Quantity e Observed Price e Observed UoM e Rejected status e Comments To modify Observations follow the steps as mentioned below gt Load the Observations by following the steps mentioned in section 4 2 7 gt Navigate to any observation and modify values in any of the 5 fields mentioned above EY HE Data Validation and Averaging Oman CTRY HHC DB 9 Dec s3db Data Validation and Averaging Module Save E Print 6 nep Exit v Invalid Observations EX Rejected Observations C Change Database Products File Name From Date Location Location Type To Date Click here to view selected filters a em d Outlet Outlet Type Averaging Method Te Export MinMax Price Ratio Limit Var Coefficient Limit C Tolerance Rato Limit 4 0 6 x TValve Limit 1 v Cancel Products Observations Quotations Location Name LocationType OutletCode OutletName OutletType Obs Date Obs Qty Obs UoM Code Obs UoM Obs Price Conv Price Tolerance Ratio T Value Comments Validated As Seeb 1 57 Market 32 1 2009 01 01 1 426 0 Bawshar 1 56 Maket31 1 2009 01 01 2 052 0 Bawshar 1 56 Market 31 1 2009 02 01 0 516 0 As Seeb 1 57 Market 32 1 2009 02 01 0 5
90. re 4 2 15 4 Database changed Message Change Default Database 5 2 16 Export Average Prices and Observation Details The Data Validation and Averaging application facilitate to download either Average prices only or Observation Details or both in an Excel file Follow the steps mentioned below to export Page 65 of 73 gt On the Data Validation and Averaging screen select appropriate filter criteria such as From Date To date and Averaging method all three are mandatory then optional filters like Products Locations and Outlets etc gt Click on the Export button Data Validation and Averaging Oman CTRY_HHC_DB 9 Dec s3db c gt Prnt e Help ext _ Change Database Products v File Name v From Date 2008 10 18 55 _ Indude validated observations Get Data Location iv Location Type iv To Date 2009 12 18 53 Click here to view selected filters Outlet v Outlet Type Averaging Method arithmetic Mean v MinMax Price Ratio Limit 0 6 gg Var Coefficient Limit 5 v Tolerance Ratio Limit 0 6 E TValue Limit 1 y Products Observations Quotations Product Name ProductCode of Price Quotations Average Price Min Price Max Price Min Max Price Ratio Var Coefficient Figure 4 2 16 1 Export Average Prices and Observations gt System will display a small screen as shown below with various Export options If you want to export o
91. roducts v Fromdate 2009 04 04 GetData Import Data Entry Mode EEE Invalid Observations E Todur NC IRAE Cancel Export Click here to view selected filters v Rejected Observations EZEENM oso CT RI RN RN NN RN RN 2009 04 01 241202 100 4 15 40 DC2 1 0 2009 04 01 451001 13 57 100 4 1 89 1 89 DC3 OMR 1 0 2009 04 01 1023603 13 103 325 00 2 0 30 0 37 DC3 OMR 1 0 2009 04 01 211301 12 94 100 4 8 80 8 80 DC2 OMR 1 0 2009 04 01 101101102 13 58 20 00 1 12 51 15 64 DC3 OMR 1 0 2009 04 01 1021502 12 56 49 00 2 0 22 0 27 DC2 OMR 1 0 2009 04 01 101418101 12 56 226 00 2 0 65 0 81 DC2 OMR 1 0 2009 04 01 101311703 11 1 1 00 1 0 44 0 44 DC1 OMR 1 0 2009 04 01 10123202 13 103 454 00 2 1 04 1 30 DC3 OMR 1 0 2009 04 01 1023602 12 105 340 00 2 0 21 0 26 DC3 OMR 1 0 2009 04 01 101611101 14 13 1 00 1 0 50 0 50 DC4 OMR 1 0 2009 04 01 1019401 12 66 150 00 2 0 74 0 93 DC2 OMR 1 0 2009 04 01 450603 13 58 750 00 5 1 35 1 69 DC3 OMR 1 0 2009 04 01 910902 13 58 100 51 1 35 1 35 DC3 OMR 1 0 2009 04 01 450103 12 56 450 00 2 0 39 0 49 DC2 OMR 1 0 2009 04 01 10142103 12 66 30 00 4 1 15 1 46 DC2 OMR 1 0 2009 04 01 101105202 13 58 400 00 4 0 11 0 14 DC3 OMR 1 0 2009 04 01 101611102 12 11 1 00 1 0 55 0 55 DC2 OMR 1 0 m pooe 04 01 10222 57 400 00 2 1 39 1 74 DC3 OMR 1 0 Record 2 ds op Rm m Page 29 of 73 Figure 4 1 12 1 Empty row in Data entry Mode
92. rvations Import Cancel Export Click here to view selected filters EH Rejected Observations Obs Obs UoM C ObsP Conv Price Collector N Cure Currency Exchange R Comm Change Database Figure 4 1 6 1 Set Exchange Rate System will display a message as shown below Figure 4 1 6 2 Set Exchange Rate Save Message 5 1 7 Download Data Entry Template The Data entry Template is nothing but a blank Excel sheet with only column headers which are required for capturing an Observation Columns with a sign in the column header represents Mandatory columns and all other columns are optional Follow the steps as mentioned below to download the Data Entry Template file gt Click on the Download Data entry Template hyperlink Page 21 of 73 Data Entry Oman CTRY E um T no E HP opua Enny MARET meS L 1 pe i a oe 9 we Products v Fonde 205228 I Getto mw A Darts Entry Mode Otesrvations Fienie v Tone 320033 E Carod epee Chck here 12 vier selected fibers E Rejected Obes atone t IM Preckt c Leeaton c utetc om eu onc cteP 7 mo 4 m Figure 4 1 7 1 Download Data Entry Template Select the download folder provide a file name and click on Save al Save As
93. rvations Quotations Product Name gt G 1f IND AN SE Basmat TILDA Bacged Indian 5Kg 101101101 Basmat Maqbool 3AGGED INDIAN 20Kg 1011011C2 6 11 122 10 765 11 375 0 946 2 308 L Basmat Al Jabal Al Akhear ndis 45Kg 101101103 8 13 058 12 502 13 15 0 909 3 977 SOB PAKISTANI 1011012 if Basmat BOX PAKISTANI 1Kg 1011012C1 5 0 224 0 2 0 25 mm 7 C Basmat GUARD Bagged Pakistan Kg 1011012C2 6 2 46 2 365 2 537 0 932 if gl Basmat KFANGAR Khimgis Bagged Pakistan 20Kg 101101203 6 7 03 6 175 7 7 5802 8 478 JB OTHER RICE 1011013 if uncle Ben s Kice PLASI BAG U S A ZKG 1U11U13U1 i tz 1 28 1 534 ess 6 17 Egyptian Rice PLAST BAG ESYFIT 2Kg 1011015362 4 0 513 0 475 3 525 0 905 ars LT ge Basmat Sun While Bayyed Assbalia 2Kg 1011013C3 6 0 649 0 604 2 695 0889 5 805 5 Lour 101102 i L Brown Four NO 2 Atta PAPER EAG OMAN FLRMILL SKg 10110201 ES 0 757 0 79 3 805 0 981 0 857 0 Plain Flour All Purposa Flour Paper Bag Dakabi O 10110202 6 0 209 0 295 2 225 0 877 6 042 if Rrown Four NO 1 Maida Plst FAg OMANF SKg 10110n 0n 8 6 862 7 975 n 93 2 858 G CIB pasta 101103 LAMP Vermicelli 2as a PLS PAPER KOLSON U A E 450 a 10110301 8 0 168 0 155 2 175 6 5 292 45 Vermicelli as a Al haleeja U A E 453g 10110302 6 0 16 0 13 2 178 Sars 12 123 o Ver
94. servation Summary for Products How to Set MinMax Price Ratio Limit How to Set Variation Coefficient Limit How to Validate and calculate Average Prices for Products How to Set Deviation How to Set T Ratio Limit How to View Observation Details How to modify Observation Details How to Save Validated Observations How to Reject Observation How to Change the row highlighting color of the rejected observations How to Change the row highlighting color of the invalid observations How to Change the Default Database How to Export Observation Summary for Products and Observation Details 5 1 Data Entry Application 5 1 1 Launch the Data Entry application After the installation The HHC Module on installation creates a Shortcut along with an icon for the Data Entry application on the desktop It also adds it under the Program Menu User can click on the shortcut or click on the Start Menu gt Programs All Programs in Vista gt ICP 2011 HHC Modules gt HHC Data Entry Page 13 of 73 5 1 2 Figure 5 1 1 1 Data Entry Shortcut on the Desktop _ Microsoft Visual SourceSafe By Data Processing Module BD Developer Express v6 3 Uninstall HHC Modules Lotus Applications Ji Microsoft Framework SDK v2 0 Microsoft Office 4e Microsoft SQL Server 2005 d Microsoft Visual SourceSafe 4 amp Microsoft Visual Studio 2005 di Mozilla Firefox J Optional Applications Remote Access 4 SAP amp BW 4 amp SQLite OD
95. ssage as shown below Loading Data Please Wait Saving Observations Figure 4 1 11 3 Saving Observation Data Saving gt After the observations are saved it will display a messages as shown below o If all observations were valid Figure 4 1 11 4 Page 28 of 73 Saving Observation Data Success Message o If invalid records were also present at the time of saving system will display the count of the records that has been saved successfully as shown below Save Error Figure 4 1 11 5 Saving Observation Data Error Message 5 1 12 Add New Observations via screen There are two modes in which the Data entry screen can display observations in the Observations grid 1 Data Entry Mode Check the Data Entry Mode Checkbox This mode shows only the columns which are useful for entering a new Observation detail 2 Detailed View Mode Uncheck the Data Entry Mode Checkbox This mode provides detailed information about Observations Along with the columns that are displayed in Data entry Mode it also displays columns such as Product Name Location Name Outlet Name UoM Name etc Either of these two modes can be used for adding a new observation via screen In both Modes the first row in the Observations grid remains empty which can be used for entering a new observation E osta tren z Oman TY D838 NONU NUN UN UN NN B Pr Exit te Preview J Download data entry templat P
96. t settings will be cleared 6 1 2 Sorting Records This feature provides the ability to sort data against one or multiple columns When sorting is applied to a view rows are re arranged to meet the current sort settings Page 69 of 73 To sort data against a Grid View s column or to change the column s sort order an end user can click its column header The column s current sort order is indicated by the sort glyph a small arrow displayed at the column header s right edge If the data is sorted in ascending order the sort glyph represents an up arrow When sorting in descending order the sort glyph is displayed as a down arrow If the column isn t sorted the sort glyph is hidden In the following image data is sorted against the Country column in ascending order and against the City column in descending order Company Mame E Country E City v z Phone G day Mate Australia Sydney 02 555 5914 Pavlova Ltd Australia Melbourne 03 444 2343 Refrescos Americanas Brazil Sao Paulo 11 555 4640 For ts d rables Canada Ste Hyacinthe S14 555 7955 Ma Maison Canada Montr al 514 555 9022 6 1 3 Filtering Records Filtering allows you to display a subset of records from a data source When filtering is applied to a Grid View only those records that meet the current filter criteria are displayed You can filter data against a single or multiple columns In a Grid View an end user can apply change or remo
97. tem Requirements The World Bank recommends a standard set of hardware and software requirements that are conducive for optimal installation and functioning of the PCM module Software Requirements The best suitable software configuration is recommended below Operating System Windows XP or later Application Software Microsoft Excel 2003 and above Page 6 of 73 3 Technical Architecture for ICP Country Software PRICE DATA FLOW VB NET OPTION ee ee ee ee eee IHSN TOOL KIT E Import observation data Data Entry Module a Ul LAYER Metadata entry File attachments Excel export Nesstar Database SOL ite Database Excel export Average prices calc Module Excel export ul c cT tl x I m mm oun oum ou ou Se bom nw GAS CURRO CERRO CR CA ANS CAE CAE CAN CADO CADO AS CRAS CAO OUO UG UO oU Figure 1 Technical architecture HHC This architecture represents a standalone application for each module and all the modules will be using the same SQLite database e Data Entry Module o Master lists received from the Region will be uploaded into this module and the u
98. tion Location Type To Date 2009 12 18 Click here to view selected filters Outlet Outlet Type Averaging Method arithmetic Mean 5 Var Coefficient Limit 5 Tolerance Ratio Limit 2 TValue Limit 1 Cz praene 0 WedudtCode No of Price Quota Average Prce m Pree Mm Price wn Max Price Ratio Var Coeficen DED T BASMA NDIAN 1011011 m v f Basmati TILDA Bagged Indian 5Kg 101101101 9 m v Basmati Maqbool BAGGED INDIAN 20Kg 101101102 9 mE PERN E a N Ie T 12 G Basmati PAKISTANI 1011012 m Basmati BOX PAKISTANI 1Kg 101101201 9 v Basmati GUARD Bagged Pakistan 5Kg 101101202 9 Basmati KHANGAR Khimgis J Bagged Pakistan 20Kg 101101203 9 OTHER RICE 1011013 m 1 Uncle Ben s Rice PLAST BAG U S A 2Kg 101101301 9 m Egyptian Rice PLAST BAG EGYPIT 2Kg 101101302 6 m L Basmati Sun White Bagged Australia 2Kg 101101303 9 OG riour 101102 m i Flour NO 2 Atta PAPER BAG OMAN FLRMILL 5Kg 10110201 9 m MP Plain Flour All Purpose Flour Paper Bag Dahabi O 10110202 9 m i MP Brovm Flour NO 1 Maida Plst Bag OMANFLRMILL 5Kg 10110203 9 OB Pasta 101103 m D H AMP Vermicelli Pasta PLS PAPER KOLSON U A E 450 g 10110301 12 m Vermicelli Pasta Al Khaleejia U A E 453g 10110302 9 m i tof Vermicelli Pasta PLS PAPER SIPA France 453g 10110303 9 OOH macaroni 101104
99. tional tasks you would like Setup to perform while installing ICP 2011 HHC Modules then click Next 6 Now on the next screen Click Install Page 10 of 73 i Setup ICP 2011 HHC Modules Ready to Install Setup is now ready to begin installing ICP 2011 HHC Modules on your computer Click Install to continue with the installation or click Back if you want to review or change any settings Destination location CMLserswb353828Documents ICP 2011 HHE Modules Additional tasks Additional icons Create a desktop icon 7 On successful completion of the installation it will display the screen as shown below Click on Finish Completing the ICP 2011 HHC Modules Setup Wizard Setup has finished installing ICP 2011 HHC Modules on your computer The application may be launched by selecting the installed icons Click Finish to exit Setup Page 11 of 73 5 Household Price Collection Module Features The Household Price Collection Module HHC is a Desktop application that is provided to the country offices for capturing and then validating and averaging the price data for the Household consumption items The HHC Module comprises of two sub modules both of which are independent Desktop applications and share the same database e Data Entry To capturing the Price data for the predefined products Items e Data Validation and Averaging To Validate the data that is captured in the Data Entry Module and then gen
100. ve filtering via a column s Filter Button Clicking it invokes a filter dropdown list which by default contains the predefined All Custom Blanks and Non Blanks values along with the values of items At the top of the list the most recently used filter conditions are displayed The following image shows the filter dropdown list invoked for a column in a Grid View Status a Postponed Postponed Custom Blanks Mon blanks Mew Postponed Fixed Rejected It s also possible to add custom filter items to the filter dropdown list which can be used to apply any filter criteria to the data when they are selected After a filter has been applied to the current View the filter panel appears by default at the bottom of the View Le tl PLP PS Ll Li i El i a T Page 70 of 73 The filter panel displays a string which represents the current filter criteria and contains buttons to disable enable and clear the filter and invoke the Filter Editor It also provides access to the most recently used filter criteria applied to the View 6 1 4 Hiding Unused Columns The customization form provides facilities for adding and removing columns from a View at runtime by using drag amp drop Dragging the column by its header and dropping it within the customization form client area hides the column from the current View The column reappears when the header is dragged from the customization f
101. zation form Dragging a column header from the customization form onto the column header panel 6 2 3 Reordering Columns and Nodes Effect Invokes the customization form Hides the corresponding column Makes the corresponding column visible The following operations can be performed by end users to rearrange columns and nodes gt Dragging a column header and dropping it to a new position within the column header panel gt Dragging a node indicator and dropping it to a new position Page 72 of 73 6 2 4 Sorting The following operations can be performed by end users to apply or cancel sorting by column values Action Clicking a column header Clicking a column header while holding the SHIFT key pressed Clicking a column header while holding the CTRL key pressed Selecting the Sort Ascending or Sort Descending items in the column header s context menu Effect Toggles the column s sort order The previous sorting is removed Toggles the column s sort order The previous sorting is preserved Removes sorting by this column The previous sorting is preserved Applies the corresponding sort order to the column The previous sorting is preserved Page 73 of 73

ICP Country Software

Contents

Download Pdf Manuals

Related Search

Related Contents