Monday, March 3, 2008

Chugging Along....

The spreadsheet model has been updated! check back to the link http://www.4shared.com/dir/5878411/bcf7dabd/sharing.html, and view the file "(2) Senior Exit Project.xls." This is the newest version of the spreadsheet.

Data has been added at the bottom of the spreadsheet, to describe the cost of operating Alco HH1000, EMC NW2, and EMC E3AB units per hour in 1939. Data was collected in 1939 dollars, but as adjusted for inflation, so that the equivalent costs are displayed in 2007 dollars.

It seems that the calculated costs per service hour are slightly low. These low numbers might be attributed to the cost of fuel. In 1939, fuel was much less expensive relative to other products than it is now. When I converted the costs, Inflation was adjusted using a calculator based upon an average consumer price index, however the cost of fossil fuel has risen many times this amount.

The relatively low cost of fuel during the period of transition from steam to Diesel,provides further incentive for railroads to switch to diesel

I tried to fix all issues that were addressed with the original version of the powerpoint. Please leave further comments and suggestions. This thing is still only in initial phases.

No comments: