attached to this email you receive a data map for the transaction price part with some automated checks.
The data is from a UK survey so please do not wonder about the prices themselves.
It is an Excel map that contains several worksheets:
• Code list: the light blue codes have been included for the Thailand survey
• Data map visit 2: this is the sheet where the raw data from you should be put on.
• KV: this is the sheet that contains data (as a copy from the Data map visit 2) and automated checks as well.
When you take a look at this sheet you will see green cells that show that everything is ok and cells marked differently when a case is technically missing something or wrong.
• Check: just a copy of all the checks, this worksheet helps to get a quick overview
• Shopping list current: this is a CORE worksheet. It feeds the rest with information for most of the checks: regarding the right vehicle, the correct base list price and so on.
When you take a look at the sheet you may at first be a bit puzzled but it really is helpful and I would like to lead you through it.