Data Tool, User Manual
Contents
1. 1 2 3 4 5 6 E Put e e e a ee a ees a a a a Ban ad P na aa a aa a ed aT eed a s Pull down list containing all items Navigation buttons next previous item BH Filter settings eight checkboxes Item status Command buttons Input area Make and Model Input area Specifications Command buttons for copying make model and or specifications Command button for displaying differences in specifications 10 Command button Show pict and info no picture or picture av for picture available 11 Input area Terms and conditions The second bottom part of the input screen covers Representativity and comparability Op tions additional specifications and Notes E 150111 01 Single skinned horiz cyl storage tank Unspecified 100 cu m Delete item History Setup Z q emaj tem e BH ree eo ean e Save Check Print _Exit 5 MACHINERY AND EQUIPMENT SURVEY GENERIC 6 150111 01 Single skinned horiz cyl storage tank Po CMS no picture 32 Representativity and comparability 33 Is the productitem priced representative yes or unrepresentative no 227222222222 12 gt 34 Are the productiitem priced and the productiitem specified identical 1 or equivalent 2 O OAO O OS 36 Options additional specifications ae 38 39 1 41 42 43 44 Notes FOR THE STORAGE OF FUEL OIL THESE TANKS CAN BE USED FOR THE STORAGE OF FUEL OIL ABOVE GR2. H Engine Euro 4 compliant Terms and conditions Order quantity me me nit price Pome me installation costs o ow S wb S Delivery costs CE ves ws O Discount ooo o ys S vws S g Non deductibletaxes doo ves e OT 31 Total unit price net of deductible taxes and discount Computeprice gt 32 Representativity and comparability 44 gt bI Input_Sheet Spec_Sheets History Surmmary_products Summary Surmmary_resul Be Wate Prt fen Pre Peace Prin Pe Pek a Bae as EE Vent Died aaa es etme Veet Viet pec is eC ery Tied Wt teal Paes Wa Now move the cursor to the entry for the Ford Transit 260 van and click 11 vw vY Priced V Unspec V Repr Item Item T BH a a eee Exit MACHINERY AND EQUIPMENT SURVEY SPECIFIC 150121 03 Van Product Proposed Specified Show pict Make and nationality Ford USA Cid lt Copy Model Transit 260 SWB Medium Roof c Specifications Metric Copy gt Imperial Copy gt National Show diff g 10 11 12 Terms and conditions Order quantity o oOo o o o o o oo odoo me me Unit price Pome me Installation costs CE ooo S o S Delivery costs oOo oOo o o o ooo doo oyes O oyes O O Discount o o o o ooo S oves S yeso O O CCC CS SCSC C C C C C C C C C C C C CCCCC Non deductible taxes O Z o o do ves CE ves UO Total unit price net of deductible taxes and discount Compute price gt Representativity and comparability M14 P
3. The parameters are OK 13 In addition the following dialog is displayed Create item history entry Them 150121 03 Van f Ford USA f Transit 260 SVB Ok Medium Roo ok Date and time 23 03 2011 15 05 Abbrechen User Peter Tabor Action Item priced Standard comment Please add your comment Sample Input The text you enter here as well as date and time of this action Saving will be stored in the history of the priced item and can be retrieved afterwards by clicking on the History button in the data input screen You do not need to enter a comment here but it may be useful to do it Please note Saving item information will also save the Data Tool file to disk in order to ensure that the database is immediately saved to disk and avoid any possible data loss After saving has been completed the item is indicated as being priced in the item status area 14 3 3 Special Situations 3 3 1 Moving to next Item without prior Save Now we assume that we have selected a new item e g the next item after the van from the example above After having entered some information for this item we forget to check and save the item and click on next item In such a situation the Data Tool notes that the last saved information for the item and what is present in the input sheet differ The tool then reduces the zoom factor to be able to display the complete specification sheet
4. 01 Van Unspecified w Delete item History Setup 150121 01 Van Unspecified t all a eee FEN SEn 150121 02 Yan Mercedes Benz Germany Sprinter 313 CDI Save Check Print Exit 150121 03 Yan Ford USA Transit 260 SWB Medium Root 150121 04 Yan W Germany T 30 Country 160121 05 Double cab pick up Toyota Japan Hilus HL 2 Double Cab WD x 150121 06 Delivery scooter Yamaha Japan Vity no picture z 150121 07 Delivery scooter Honda Japan ANF 125i Innova S pec ified Show pict 8 150121 08 Delivery scooter TGB Taiwan Delivery 150121 09 Diesel minibus Unspecified d Copy 150121 10 Diesel minibus Mercedes Benz Germany Vito Traveliner A 150121 11 Diesel minibus W Germany Caravelle ee lt Co py 16012112 Lorry chassis cab Mercedes Benz Germany Sprinter 516 CDI e 10 150121 13 Lorry chassis cab Volvo Sweden FLL 240 HP 4X2 Rigid National Show diff 150121 14 Lorry chassis cab Ford USA Transit 350 LWB DAW Awo 16012115 Lorry chassis cab Y Ww Germany Crafter CR 35 12 150121 16 Tractor unit Unspecified 13 15012117 Tractor unit Mercedes Benz Germany Actros 2644 S 624 LS 15012118 Tractor unit Mercedes Benz Germany Actros 1844LS 42 14 150121 19 Tractor unit Scania Sweden R 400 LA 42 MINA 150311 01 Computer operating system f Unspecified f tem Unspecified re
5. 21 21 21 1 Preliminary Remarks For the Machinery and Equipment Survey World Bank International Comparison Program 2011 an Excel tool the Data Tool will be used to make item specifications and record pricing information on Equipment Goods The major goal of this tool is to provide an easy and reliable method for recording the data This user manual is intended to show how to use the Data Tool 2 Installation 2 1 Technical Requirements The Data Tool requires MS Office 97 or newer installed on a PC running Windows NT 2000 XP or newer Depending on the national version of the operating system and of the MS Office version some mes sages may differ from the ones in this manual This manual was created on a PC with Office 2000 In order to use the Data Tool it is absolutely mandatory that VBA macros are enabled You may need to change the safety level in your Excel version to allow for enabling macros 2 2 First Start and Setup Please copy the Excel file data_tool xls you have received and the subdirectories containing the item images to a separate folder then open the file data_tool xls there by double clicking on it Depending on your safety settings in Excel a dialog may be displayed which asks whether or not to enable macros Please always enable macros for the Data Tool otherwise it will not run properly In case you do not get a dialog and macros are disabled automatically please change the Excel safety level appro
6. be done later during the analysis of the Data Tool files In the input fields Text for the YES button and Text for the NO button please enter the text appear ing on those buttons in the operating system installed on your PC If you are not sure about the texts just click on the Test button A Test YES NO dialog will then appear In a German Windows ver sion this may e g appear as follows Test YES NO The left button should be the YES button The right button should be the Wo button Please click on either of the buttons to exik Thus the texts to be entered in the setup dialog for the German version should be JA and NEIN In order to save the settings made please click on the Save and exit button Clicking on the Exit without saving button results in discarding the changes made in the setup dialog After clicking on the Save and exit button you will receive the following message 2 3 User identification After completing the first setup dialog see above and whenever the Data Tool is started a dialog will ask for the name of the Data Tool user Set user name Enter the name of the data tool user fmin 2 char Cancel l This name will be used for recording item history see below The name entered will be saved and suggested as the default value for the next Data Tool start After completion of the first setup and the user identification the data input scre
7. for the item highlights all changed cells with yellow colour and asks the user whether or not to save the data D 4 B6 C 1 ASML Vae YW Germ sny EAEL History al Stems ttem BH Bu Beie Bure ee e Save Chec Print Exit 5 MACHINERY AND EQUIPMENT SURYEY SPECIFIC Comi 6 150121 04 Yan Mito picture 7 Product Proposed Specified Show pict a Make and nationality W Germany Copy 3 Model t Co 10 Specifications Metric Copy National Show diff u i lt Copy 12 2 lt Copy 13 3 lt Copy 144 lt Copy 6 5 lt Copy 16 6 Wheelbase 8 mm Bins 4 Copy wo loadaeas Z o oam 46 sg ft lt Copy 1 8 Interiorheight Om Bins 4 Copy 13 9 Sidedoor fsliding tsliding lt Copy 20 10 Reardoors Z o O es es lt Copy aE a r 22 2 nn Microsoft Excel 23 Terms and conditions 24 a Orderquantity me 25 b Currency o Ooo specify spel 26 c Unitprice me ar d nstalatoncoss O n d po 28 e Delivery costs Tes So d ee Boi ae j 23 fF Discount o owes oo yesi g Mon deductible taxes PO OS A Total unit price net of deductible tazes and discount Compute price gt Representativity and comparabilit Is the productfitem priced representative yes or unrepresentative no re the productritem priced and the productlitem specified identical 1 or equivalent 2 Opt
8. 1 07 Packaged steam boiler Viessmann Germany Vitoplex 200 SX2 1950 kw 150111 08 Packaged steam boiler Viessmann Germany Vitoplex 200 SX2 1950 kw 150111 09 Hacksaw Stanley USA Multiposition hacksaw 15 120 150111 10 Hacksaw Stanley USA High Tension Hacksaw 150111 11 Hacksaw USAG Italy 2005 150111 12 Automotive tool set Facom France Tool set BT 14 150112 01 Portable screw compressor f Unspecified no picture Show pict 150112 02 Portable screw compressor f Atlas Copco USA KAS 67 Dd Series 7 10 150112 03 Portable screw compressor Atlas Copco USA KAS 7 Dd Series 7 National 11 150112 04 Diesel engine general purpose f Unspecified lt Copy 150112 05 Diesel engine general purpose Yanmar 3TNV83 DS4 12 15012 06 Industrial petrol engine Honda Japan GX 270 SWC 4 13 150112 07 Industrial petrol engine Honda Japan GX 160 SX 4 g 150112 08 water pump stationary Unspecified 14 15012 09 water pump stationary Grundfos Denmark TP 32 320 2 lt 15 pump stationary t Grundfos Denmark t TP 32 3802 pal cat ll eieiei cto EEIE Eg 16 6 lt 17 7 Classification of steel European norm EN 1025 5 275 EN 10255 275 18 8 Tested pressure inner outer 0 3 0 4 bar 0 3 0 4 bar s 199 lt 20 10 20C 50C 2 F 120 F lt 21 11 Uncoated internally standard finiish lt 22 12 appr
9. 1 for identical 2 for equivalent All other values result in an error message 3 1 13 Options The input made in this area A37 E43 is not checked in the Data Tool 3 1 14 Notes The input made in this area A45 E54 is not checked in the Data Tool For most of the specific items a website address of the manufacturer is provided in the Notes sec tion In the example displayed below item 150111 10 a high tension hacksaw manufactured by Stanley USA the website address is wii Stanleytools cam You may jump to that website by clicking on the link 10 3 2 Input of a Sample Item Let us assume we want to specify item 150121 03 a Ford Transit 260 SWB Medium Roof van We found the exactly identical product and it is an important item in the market The price we found for the van is 13 million XAF the discount is 10 1 3 million XAF there are neither installation costs nor or delivery costs or non deductible taxes These are just assumptions for the sample input for more detailed information on pricing items please refer to the briefing notes There are different ways of selecting the item but knowing it is in BH 6 of 7 and assuming we are in BH 1 clicking two times on the Prev BH button takes us to the beginning of BH 6 BH 7 Next BH 1 BH 1 Previous BH 7 Then click on the down arrow on the right hand side of the pull down list to get the following A B E D E 150121
10. 9 Unspecified o b oo O o o y y o 280 ee 2e1 167 15012110 Mercedes Benz Germany vio Train 282 283 T homas o 284 169 15012112 Mercedes Benz Geman Sprnter 16 Col 285 170 15012113 Volvo Sweden FLL 240 HP 4 2 Rigid O J J S 286 171 150121 14 Ford USA Transt 350 LWB DRW RWD J T T 287 172 150121 15 V W Germany CraterCR35 se o o o O S T y 288 a A E S 289 173 150121 16 Unspecified o b o o o o y oO 290 CP pom o oooO 291 174 150121 17 Mercedes Benz Germany Actros 2644 S6x4LS5 J T 292 175 15012118 Mercedes Benz Germany acos 184418 42 baal 178l 1603119 Scania Swede Raamaa j O 294 ld 4 gt bl 4 Spec_Sheets Fi History F Summiary_products Summary Summary_results F 4 gt lt x lt lt lt 150121 10 150121 17 continued 20 4 2 Summary by Basic Heading and Item Status Summary gives the total number of items priced per BH distinguishing between the various combi nations of representativity and comparability as well as the number of unspecified incomplete and de leted items In addition to this information the number of products not items priced per BH as well as the number of priced products per BH that were both important and identical is given Number of priced ttems per basic heading Unspecified incomplete and deleted tems PRODUCTS priced Representative Not representative Unspecified Incomplete Deleted R
11. International Comparison Program 02 03 ICP 2011 MACHINERY AND EQUIPMENT SURVEY DATA TOOL USER MANUAL Global Office 4th Regional Coordinators Meeting April 20 21 2011 Washington DC Contents 1 PRELIMINARY REMARKS 2 INSTALLATION 2 1 Technical Requirements 2 2 First Start and Setup 2 3 User identification 3 DATA INPUT 3 1 Data Input Screen 3 1 1 Pull down List containing all Items 3 1 2 Navigation Buttons next previous Item BH 3 1 3 Filter Settings 3 1 4 Item Status 3 1 5 Command Buttons for Saving Checking Printing etc 3 1 6 Input Area Make and Model 3 1 7 Input Area Specifications 3 1 8 Command Buttons for Copying Make Model and or Specifications 3 1 9 Highlighting of Technical Parameters which are different 3 1 10 Displaying Item Pictures 3 1 11 Terms and Conditions 3 1 12 Representativity and Comparability 3 1 13 Options 3 1 14 Notes 3 2 Input of a Sample Item 3 3 Special Situations 3 3 1 Moving to next Item without prior Save 3 3 2 Bottom Line Prices 3 4 Delete Item 3 5 Item History 3 6 Printing 3 7 Additional Hints Enhanced Filtering and Printing 3 8 Setup 3 9 Exit 4 SUMMARIES 4 1 Item by ltem Information 4 2 Summary by Basic Heading and Item Status 4 3 Product Specification Summary by Basic Heading 5 SENDING DATA TO THE REGION OMOWOWOWOAOAN NOD fh A Se eee O O O CO oh ek a l O o1 Ol a ee ee es eC O O O amp O N N OO 20 20
12. OUND BY LAVY THEY ARE NOVY REQUIRED TO STAND IN A PROTECTIVE TRAY IN CASE OF LEAKAGE THIS TRAY CAN BE MADE OF STEEL AND SUPPLIED BY THE TANK MANUFACTURER OR OF BRICK CONCRETE ETC IT IS NOT KNOVWN AS BUNDING AND SHOULD NOT BE INCLUDED TANK TO BE SUPPLIED WITH LEAK DETECTION SYSTEM COMPLETE WITH CONNECTION KIT DIPSTICK AND A CERTIFICATE OF CONFORMITY TO STANDARD CEN 12285 AN 4 4 gt PA Input_Sheet Spec_Sheets History Summary_products Summary Summary_resul There are three input areas 12 Representativity and comparability 13 Options additional specifications 14 Notes In the following chapters the areas labelled 1 to 14 in the two parts of the input screen are described in more detail 3 1 1 Pull down List containing all ltems From this list which is displayed when you click on the down arrow on the right hand side of it you can directly select an item even when it is in a BH not activated in the setup dialog The entry dis played in the box corresponds to the currently selected item The items appearing in the list are sorted by BH product and item E Delete tem Jp History J Setup Save Check Print Exit Country CM Specified 150111 04 Stainless steel beer keg Unspecified 50 litre standard 150111 05 Packaged steam boiler Viessmann Germany Vitomax 200 HS model 237 150111 06 Packaged steam boiler Viessmann Germany Vitomax 200 HS model 237 15011
13. PN Input_Sheet Spec_Sheets History Summary_products Summary Summary_resul oO Nm 0 A wn 1 2 3 4 5 6 7 E As we found an identical item we click on the two buttons for make and model as well as on the Coy gt button in the Metric column As mentioned before this causes a 1 to be entered in the com parability input field Priced Unspec Repr Iter 7 Item BH J BH Fre ces A ca wed I Check Print Exit t MACHINERY AND EQUIPMENT SURVEY SPECIFIC 150121 03 Van CM 12 lt Cop Terms and conditions Order quantity me me Unit price Pome me S Installation costs oono S wn S Deliverycosts ws ves Discount o o ooo o vs S ws S Non deductible taxes ves Pes OT N Total unit price net of deductible taxes and discount Compute price gt Representativity and comparability Is the product item priced representative yes or unrepresentative no ff _______ productiitem priced and the productitem specified identical 1 or equivalent 2 ST Options additional specifications 4 4 gt bI Input_Sheet Spec_Sheets History Summary_products Summary Summary_resul After having entered a Y in the representativity field we continue by entering the pricing information in the Terms and conditions input area Note For entering the discount we may either enter 1300000 absolute value or 10 for 10 Here the value 10 for 10 has been entered in the
14. al purpose machinery Item deletion passa empty to avoid pass 41501143 Electrical and optical equipment 5150115 Other manufactured goods n e c W BHO 150121 Other road transport W BH 7150311 Other products Text For the Yes bukkon Text For the Mo button YES ee Test Save and exik Exit without saving For this user manual CM Cameroon is used In case your country is not included in the list please select XX other countries Next the standard for the technical specifications has to be selected either Imperial or Metric To do this please just click on Imperial or Metric In case you want to protect items against deletion you may specify an item deletion password If this is left empty you will just be asked if you really want to delete an item when you select Delete item in the main input area otherwise you will be prompted for the password We propose to leave the item deletion password empty In the top right part of the dialog you find seven checkboxes one for each basic heading BH By default all these checkboxes are checked indicating that you can save data for all BH In case you want to divide the input work among several persons you can just copy the still empty Data Tool Ex cel file several times under different names and then activate each BH in exactly one of the files Please note Merging the files can not be done by the data tool user it will
15. dis count input field 12 A B C D E F g 2 7 V Priced V Unspec V Repr 4 Item Item BH BH Fee a Save Check Print Exit 5 6 l HH MACHINERY AND EQUIPMENT SURVEY SPECIFIC 150121 03 Van O OM OE lt Copy 23 Terms and conditions 24 a 25 b 26 c 27d Installation costs o o o ooo TT 28e Delivery costs es S es ST O 29 f 30g Non deductibletaxes yes S es SP o 31 Total unit price net of deductible taxes and discount Computere J 32 Representativity and comparability 33 Is the productiitem priced representative yes or unrepresentative no t i lt i yS E 34 Are the productitem priced and the product item specified identical 1 or equivalent 2 36 Options additional specifications 44 Notes ld 4 gt gt Input_Sheet A Spec_Sheets Fi History Fi Summary _products Fi Summary H Summary _resul 4 We check whether everything is ok by clicking on the Check button We get the following response Microsoft Excel The Following errors have been Found TOTAL UNIT PRICE empty or invalid After closing the message box by a click on the OK button we click on the L Compute pice button to let the Data Tool calculate the Total unit price net of deductible taxes and discounts The calcu lated value 11700000 XAF is automatically entered in the appropriate input field Another click on the Check button produces the following message ltem check Eg
16. e filters in the input sheet and se lecting the correct buttons in the Print dialog In order to print priced only please check all boxes in the filter area as shown below lw Priced Unspec y Repr y ID Incomp Deleted lw Alot repr y EQ Then click on the Print button and select All filtered items in the Print dialog 3 8 Setup The setup dialog has already been described in the First start and setup chapter 3 9 Exit Clicking on exit closes the Data Tool For safety reasons the Data Tool first asks whether the user really wants to exit Microsoft Excel Do you really wank bo exit the data collection tool Then the Data Tool checks for unsaved information specified for the currently selected item see chap ter Special situations When clicking on the Cancel button the exit process is stopped and the fol lowing message is displayed Microsoft Excel You may now continue using the editing tool 19 4 Summaries The Data Tool provides three summaries of the information entered e Summary_results item by item information e Summary summary by Basic Heading and item status e Summary_products product specification summary by Basic Heading In order to access these summaries just select the appropriate Excel sheet 4 1 ltem by Item Information Summary_results provides a list of all items with information which of them were priced whether the
17. ed for by clicking on the Show diff button to the right of the National column 3 1 10 Displaying Item Pictures In case the content of field F6 is picture av a picture for the currently selected item is available otherwise the content of field F6 is 0 picture fe for all generic items with make unspecified In case there is a picture available a click on the button Plt causes the display of the picture in a separate window like in the example shown below 150311 04 Computer operating system English language Microsoft USA MS Windows The picture window may be closed by clicking on the in the top right corner of the image window 3 1 11 Terms and Conditions In this area the information determining the Total unit price net of deductible taxes and discount have to be entered The following rules apply Order quantity any text or number no checks are applied Currency Only the local currency is valid all other values may be entered but result in an error message when trying to save the item and the item will be flagged as incomplete Installation costs any non negative number please specify 0 instead of none Delivery costs any non negative number please specify 0 instead of none Discount either a non negative number giving the discount percentage or a negative number indicating the discount in units of local currency e g 1300000 for a discount of 1300000 XAF in ou
18. en is displayed and normal data input can start 3 Data Input 3 1 Data Input Screen The data input screen is designed to fit on two pages the first covering Specifications and Terms and conditions and the second Representativity and comparability Options additional specifica tions and Notes The top part of the screen rows one to six is fixed and will be visible on both pages In order to reference the various parts of the screen more easily they are labelled with red boxes and white text in the following figure 150111 01 Single skinned horiz cyl storage tank Unspecified 100 cu m vw Priced vw Unspec v Repr v ID gt 5 item tenp BH v Incomp vw Deleted lw Not re lv EQ 4 R MACHINERY AND EQUIPMENT SURVEY GENERIC 150111 01 Single skinned horiz cyl storage tank OOOO OCM no picture 4 0 Product Proposed Specified Show pict Make and nationality Unspecified 6 lt Copy 100 cu m O EE oOo wim A ew hm Model lt Copy Specifications Metric Copy gt Imperial Copy gt National EE Show ait 9 10 ves 11 12 Terms and conditions Order quantity Jo o Ooo me Unt price one D instalation costs o o S o S e Delivery costs i do es O ws O Total unit price net of deductible taxes and discount Compute price gt Representativity and comparability 44 gt bi Input_Sheet Spec Sheets History Surmmary_products Summary Surmmary_resul
19. epresentative Total _ Ident Equiv Total Ident Equiv identical o j of o 0 o o 2 0 0 21 0 j 0 4 3 Product Specification Summary by Basic Heading Summary _Products is an extract from Summary plus a comparison with the Recommended mini mum number of products which are to be priced as both important and identical At the time of writing this manual the Recommended minimum number was set to 1 for all countries and Basic Headings Difference Representative BH Name of basic heading identical 150113 Special purpose machiner Total survey 5 Sending Data to the Region After having finished the input work please send the completed data_tool xls file s to the Regional coordination team for validation 21
20. ions additional specifications 44 Notes manu tbo aanecommarcinbenahkiclae coy 4 gt bi Input_ Sheet f History Summary_products ri Summary r Summary_results y Ki In the example shown not all parameters have been entered properly Thus after clicking on the Yes button to save the entered information we get an error message listing what is missing or inva lid Microsoft Excel The Following errors have been Found ORDER QUANTITY empty or invalid UNIT PRICE empty or invalid INSTALLATION COSTS empty or invalid DELIVERY COSTS empty or invalid DISCOUNT empty or invalid NON DEDUCTIBLE TAXES empty or invalid TOTAL UNIT PRICE empty or invalid REPRESENTATIVITY empty or invalid After clicking on the OK button we have two choices 15 Microsoft Excel Sorry the parameters are not correct complete Click YES to save incomplete specifications anyhow Click WO to continue editing without saving Clicking Yes results in saving the information and marking the item as incomplete No moves on to the item we wanted to go to without saving the information 3 3 2 Bottom Line Prices Let us use the data from the sample input the Ford van again Assumed we phoned the dealer again asking for a better bottom line price and he comes up with a bottom line price of 10 million XAF Instead of calculating an odd discount percentage we can either just enter this price in the T
21. lt all eight checkboxes are checked This filter is used during item navigation as well as for printouts Filtering is available for the following e tem status priced unspecified incomplete deleted e Importance important not important e Comparability identical equivalent To change the filter just click on corresponding text or checkbox Please note that the hot spot of the cursor hand used is not the tip of the index finger but a little bit below it If you click with the tip of the cursor hand index finger on the bottom line of the Priced checkbox the status of the Incomplete checkbox will change sorry we can t do anything about this 3 1 4 Item Status The item status is displayed in the yellow area There are four options as follows Priced The item is formally correctly priced and saved Unspecified These are items for which no information has been saved or which have been priced but deleted af terwards with throwing away the entered information Deleted This indicates an item for which information has been saved and which has been deleted afterwards During the deletion process the user decided to just mark the item as deleted but keep all entered information Incomplete The item has been saved with some information being formally wrong or incomplete The advantage of having the option to save incomplete or wrong information is that you may have started enteri
22. ly deletes the data entered for this item and marks the item as Unspecified the correct action in the first situation 16 3 5 Item History When saving or deleting an item the user will be prompted for an additional comment In the message box displayed additional information item name data and time user name action will be given This information as well as the comment entered by the user will be recorded in the History worksheet In order to list the history of an item please select the appropriate item and click on the History but ton The history for the corresponding item will be filtered you will get a display like the following ltem Date andtime User Action Comment 150121 03 21 03 11 14 00 Initialised Data tool creation 150121 03 25 05 11 15 05 Peter Tabor ltem priced Sample input 3 6 Printing A click on the Print button causes the following menu to open Print menu All Filtered items For this basic heading ll Filtered items All items For this basic heading All items Print nothing just exit The user may now select to print e this item the currently selected one only e all filtered items for the currently selected BH e all filtered items e all items for the currently selected BH e all items In addition the user may select to print nothing and just exit the print menu To avoid printing too many pages by mistake the Data Tool gives an extra message when
23. ng data for an item and then notice some missing information Instead of erasing the already entered in formation and re entering it later you can just save the available information and come back to the item later Here using the filter comes in In order to find such an item later de select all checkboxes except Incomplete and then click on the Next item button The Data Tool will then find the next item with status Incomplete Each possible status is additionally signalled by the appropriate colour 3 1 5 Command Buttons for Saving Checking Printing etc The command buttons in this area are intended for e Saving the information entered for the currently selected item e Checking the information entered for the currently selected item e Starting the printing dialog e Exiting the Data Tool e Deleting the currently selected item e Displaying the history of the currently selected item e Starting the setup dialog 3 1 6 Input Area Make and Model After having selected the appropriate item data input normally starts in the input area for make and model In case the proposed make and model are ok you may click on the lt Copy button on the right hand side of the input field instead of entering the text yourself Please note that the make and model have to be entered for all priced items as well as the technical specifications 3 1 7 Input Area Specifications In this area the specifications of the
24. otal unit price field and save the item or enter the correct discount The first alternative would result in a warning as the price calculated from the different price component does not match the price entered whereas entering 3000000 in the discount field and then clicking on the Compute price button re sults in the correct bottom line price to be calculated and entered 3 4 Delete Item Deleting items can be used for two different purposes First having specified the correct parameters but for the wrong item second to maybe temporarily mark an item as incomplete as we want to modify something later because we are not sure about all the parameters In both situations we start with selecting the item and clicking on the Delete item button Depending on whether or not we specified an item deletion password in the setup dialog we get one of the two following dialogs Delete item K Enter item deletion password Abbrechen After clicking on the Yes button first case or entering the correct item deletion password and click ing on the OK button the Data Tool offers two choices Delete item Click YES to keep data fand mark item as DELETED Click WO to delete data Cand mark item as UNSPECIFIED Clicking on the Yes button results in just marking the item as Deleted but keeps the data this is what should be done in the second situation described Clicking on No real
25. ox 8297 kgs 18253 Ibs lt 23 Terms and conditions 24 25 26 27 28 29 30 c 31 Total unit price net of deductible taxes and discount 32 Representativity and comparability lq 4 gt bI Input_Sheet Spec_Sheets History Summary_products Summary Summary_resul In order to select an item move the cursor to it the cursor is followed by the dark blue highlighting line and click on it The Data Tool then copies the appropriate texts etc from the database to the input screen In case you selected an item in a BH which was not activated in the setup dialog you will get a corresponding warning 3 1 2 Navigation Buttons next previous Item BH Using the long pull down list involves a lot of scrolling to select the appropriate item As an alternative the additional navigation buttons for selecting the next previous item BH may be used Clicking on one of them lets the Data Tool move forward or backward in the list of items until an appropriate item is found During this search the settings made in the filter area see next paragraph are respected In case no item matching the filter is found you will get the following message Microsoft Excel As a consequence the last selected item will be displayed 3 1 3 Filter Settings In order to allow for easier navigation filter checkboxes have been included e Friced r Uns pec lw Repr e ID r Incomp y Deleted y Mat repr y EQ By defau
26. priately see 2 1 After the first program start the setup dialog of the Data Tool will automatically open up Reporting country cM Which basic headings shall be useable in this Excel File meh t EE eet W BH 1 150111 Fabr metal products except mach and equipm Standard technical specifications C Imperial Metric BH 2 150112 General purpose machinery BH 3 150113 Special purpose machinery Iker deletion password leave BH 4 150114 Electrical and optical equipment empty to avoid password query i BH5 150115 Other manufactured goods n e c BH 6 150121 Other road transport BH 7 150311 Other products Text For the Yes button Text For the No button YES No Test Save and exik Exit without saving The first thing to do is to select the appropriate country Please select the appropriate country from the pull down list that appears when you click on the down arrow next to the Reporting country input box At present this list contains the following entries e CM Cameroon e KE Kenya e ZA South Africa e AR Argentina e BZ Brazil e CO Colombia e AU Australia e CN China e IN India e XX other countries Reporting country Which basic headings shall be useable in this Excel File Aa oth t 4x other country 1 150111 Fabr metal products except mach and equipm standard technical sp 201501120 General purpose machinery C Imperial j 3150113 Speci
27. priced have to be entered Please note that if data are given in the Metric or Imperial columns the corresponding specification input field column E has to be filled in too 3 1 8 Command Buttons for Copying Make Model and or Specifica tions In cases where the priced product item is identical or nearly identical to the proposed one all or at least most of the technical parameters as well as the make and model should be identical to the en tries in the Metric or Imperial column or in the range C8 C9 proposed make and model To facili tate input there are C buttons in the Imperial and Metric columns In order to copy all parame ters from the Imperial or Metric column click on the appropriate one Please note This also causes the item to be marked as 1 for Identical in the Representativity and comparability input area To just copy single parameters click on the c button on the right hand side of the input field Please note Depending on what you specified in the setup dialog either the metric or the imperial parameters will be copied 3 1 9 Highlighting of Technical Parameters which are different Upon display of an item in the input sheet the technical specifications of that item which are different to both texts values given in the Imperial and Metric columns will be highlighted by a yellow cell background This can not be done continuously but can be ask
28. printing more than one page Microsoft Excel Do you want to print these 19 pages Cancel Please note The Data Tool always prints to the default printer so please make sure to select the proper printer in advance In case an error occurs during printing the Data Tool issues an appropriate warning 17 The printout is done with one item per page additional information is given in the page footer MACHINERY AND EQUIPMENT SURVEY Country Y 150121 03 Van Product Proposed Specified Make and nationality Transit 260 SWB Medium Roof Specifications Metric i National ayload 966 kg ross vehicle weight 2800 kg 5720 Ibs ype of engine Duratorq TCDi Diesel Duratorq TCDi Diesel ngine capacity ngine power output ront wheel drive rakes All disc xle ratio Wheelbase i sige door SSCS ao tng Terms and conditions a Order quantiy ee p fewe O e Cy gt 1 2 3 4 5 6 F e 9 10 Total unit price net of deductible taxes and discount Representativity and comparability Is the product item priced representative yes or unrepresentative no Lo Are the product item priced and the product item specified identical 1 or equivalent 2 Options additional specifications International Comparison Program 2011 Page 1 1 Item 160 Item Status PRICED 18 3 Additional Hints Enhanced Filtering and Printing Special printing tasks can be performed by appropriate settings of th
29. r example Non deductible taxes any non negative number please specify 0 instead of none Total unit price net of any positive number deductible taxes and discount In case a value is entered that is not valid for the input field e g a negative number in the Total unit price field a corresponding error message is given As the message is a standard Excel message it varies depending on the national version of your MS Excel software Microsoft Excel x The value you entered is not valid 4 user has restricted values that can be entered into this cell Cancel The total unit price may be calculated and entered in the input field by clicking on the Compute pice button If you modify this value later or manually enter a value that does not match the calculated one with a tolerance of one unit of the local currency a message like ltem check The parameters are OK but the TOTAL UNIT PRICE is inconsistent with the other given values will be displayed when you try to save the item or when you click on the Check button In addition in the Summary Results List described in a later chapter such an item will be flagged correspond ingly 3 1 12 Representativity and Comparability In the Representativity field only Y or N may be entered either in capital letter or in lower case All other values result in an error message In the comparability field only 1 or 2 may be entered
30. y are priced as identical or equivalent and whether the Data Tool user specified the item to be impor tant In cases where the Total unit price net of deductible taxes and discounts entered does not match the price which would be calculated from the pricing details the item is marked accordingly in the price inconsistent column Summay_results is not updated automatically In order to update this summary please select the Summary_results sheet go to the top left corner and click on the CREATE SUMMARY button The Data Tool will then create the following list SSS SE BS ESS ae ae se Se eae ae 7 CREATE SUMMARY MACHINARY AND EQUIPMENT SURVEY ICP 2011 SUMMARY RESULTS LIST I Represen Not Price Parameters for Description and make Ident Equiv tative priced inconsistent generic items 266 cc E E E E E 267 158 150121 01 Unspecified Ci o S S T S x f y y O oaa 268 D E E S B S E A E 289 150 1502102 Mercedes Benz Goman mesa J x E 160121 03 Ford USA E 260 SW Medium Root x a S 271 161 15012104 V W Germany sid eC isis e KT 272 Double cab pickup O O o o CTU o T e S e y o 273 163 E0210 Toyota apar Hux HL Double Cab wD J x S 274 si dDeliveryscooter O Z o O J o Url e S e y o 275 163 150121 06 Yamaha Japan O Z o o o oOMy CK 276 16a 15012107 Honda Gapa ANF timoa C ooo 277 165 15013108 TB Taiwan Detnery 278 a 279 166 150121 0
Download Pdf Manuals
Related Search