Calculation of electricity hourly trains - how to do this?

[public]

Hello,

I returned with a data sample, as I said here:
http://www.excelforum.com/excel-gene...ml#post3698701
Now the situation is more complex. There have two excel sheet: one with the operation of trains and another would like to gather energy consumption for all trains in the time intervals.

Do yours think is the best way of organizing data? How do yours think I could calculate the electricity consumption of trains in a simple way? Here are a few questions that I would like a response. Please.

Any good feedback is welcome.

Best regards,
"pub"

[public]

Nobody!!!! Please, some advice