Which columns belong in a useful used-EV shortlist?

Record exact model, year, variant, market and the date of the listing. Attach a source to technical claims. Keep personal seller details and vehicle identifiers private, and distinguish confirmed fields from information still awaiting a response.

Record reported health or capacity with its method, date and baseline. Include an unknown option. Do not turn mileage or a dashboard range photograph into a health measurement just because the spreadsheet needs a number.

List your normal and demanding trips, assumed consumption, charging access and reserve. Calculate each candidate on the same basis. Include a separate result for a less favourable scenario rather than presenting only the most flattering range estimate.

Use the actual asking price, comparable insurance quotes and documented repair or service needs. Show energy-cost assumptions and uncertain resale values separately. Avoid a total that appears precise only because unknown items were entered as zero.

Keep the next action for each unresolved item: ask for documentation, obtain a quote or arrange an inspection. A useful shortlist helps prioritise evidence gathering. It should not produce an automatic buy verdict from incomplete inputs.