News forum

Unit 5: The TIDE method - Assessment

Unit 5: The TIDE method - Assessment

by Kristin Tovaas -
Number of replies: 6

Please share your responses to the unit 5 questions here.

In reply to Kristin Tovaas

Re: Unit 5: The TIDE method - Assessment

by Deleted user -

For the Netherlands I have found in HEATCO the next figures:

Cost factors for road transport emissions* per tonne of pollutant emitted in €2002
(factor prices). Nox 2600

Cost factors for road transport emissions* per tonne of pollutant emitted in €2002
PPP (factor prices). No2600

Impact factors for road transport emissions* (lost life expectancy in years of life
lost per 1000 tonnes of pollutant emitted). 56

I am very sorry to say that I do not understand the spreadsheet of the TIDE-tool, which makes it impossible for me to go further with this task (I drown in the number of facts and figures). It shows me the complexity of the problem, but in my opinion there are so many factors that are to be estimated at best will, that the outcome will still be ready to be discussed over a long time.

I have made an appointment with someone of the city of Nijmegen to talk with him about the indicators used for mobility measures, Unfortunately this appointment is beyond the time available for this course. I will finish reading the course and when I see a task I can fullfil I will be back. If not this is my final contribution to the course of impact analysis. It was very interesting, but very complex; too complex for me at the moment. Thank you for sharing this lot of information.

In reply to Kristin Tovaas

Re: Unit 5: The TIDE method - Assessment

by Deleted user -

First task

In the cost-benefit analysis cited: “Economic-environmental assessment of the first phase of Sustainable Mobility and Public Space Plan in Vitoria-Gasteiz”, the HEATCO and IMPACT values were used.

This work monetizes five factors: increasing in health, emissions, noise, accidents and travel time. The only figure I can find in the paper is the value of a statistical life: 1,5 million €.

 

The standard values provided by the HEATCO project for Spain are set for the following factors:

  • Value of the travel time saving:
    • Work (business) passenger trips
    • Non-work passenger trips
    • Freight trips
  • Estimated values for casualties avoided
  • Cost factors for road transport emissions per tonne of pollutant emitted (NOx, NMVOC, SO2, PM2.5)

 

Second task

As our colleague Bert said, the spreadsheet is very complex. In some cells, I find the word VALUE! and it seems that the formula doesn’t work. Furthermore, I can’t find the “answer sheet”.

I’m sorry but I am stuck!

 

In reply to Kristin Tovaas

Re: Unit 5: The TIDE method - Assessment

by Deleted user -

First Task:

I am sorry to say that, as far as I can know, no monetisation methods were used in local administration until now. It's now under discussion (or drafting, I'm not sure) the finantial plan for the SUMP, perhaps they have used a monetisation method, but there is no public document yet.

In reply to Kristin Tovaas

Re: Unit 5: The TIDE method - Assessment

by Deleted user -

I am just starting to look at the spreadsheet and I think there are some problems with the extraxt function in cell A1. The file name perhaps has changed since the function was written. 

It also reference the 'Quan. normalisation' sheet in 'CNG busses'!D10, and there is no such sheet. This lack of one sheet makes the dependant references fail.

I can't find the answers sheet either.

 

Jesús

In reply to Kristin Tovaas

Re: Unit 5: The TIDE method - Assessment

by Deleted user -

Dear all,

There should have been two spreadsheets available: the large and complicated one, which you can download, and also a much simplified one (with answers!), which does not seem to be available to you. I'll contact the course organiser to try to get the second one up asap!

As to the comments on the large spreadsheet. I opened up the version you could download, and it looks fine  to me. It's hard for me to say why yours doesn't work, it could be a mac/PC compatibility problem, or something else altogether.

One thing to be aware of, is that the large one is very sensitive to inputs in the wrong places. You should only change the tab names (where appropriate) and the cells surrounded by a thick black box: a change anywhere else will probably result in an error.

Also, you can, in principle, disregard the HEATCO tabs, if you wanted to make things easier. They are only there to help calculate the values if you want. If not, you could just enter values manually, or move the effect to the non-monetary section and evaluate it there.

I hope that helps a bit!

Kain

In reply to Kristin Tovaas

Re: Unit 5: The TIDE method - Assessment

by Deleted user -

Dear all, 

I am very sorry for the inconveniences. Attached you find the simplified version of the spreadsheet including as well the answers sheet. 

We well also check with the administrators to put it in the Unit. Let us know if you have any problems using this one. 

Hanna