|
DCB: I can't log altitude per second due to GPS's inaccurate altitude readings. I can't even stay still with my GPS and it read a constant altitude and when I do, it would be about 100 feet off. I used a topographical map to determine the slopes for each section... Here is a baby situation for version 1.1:
From rest at red light -> 110 m with flat ground acceleration to just under 30 mph using constant 1000 N from engine -> 70 m with 2.5º incline no engine deceleration to ~22 mph -> 90 m with 1.5º incline no engine deceleration to ~15 mph. At this point, I brake to stop for my turn. (braking because 15 mph is ssslllooooowwww)
Total distance: 270 m (.1677 miles)
Total time: 35 seconds
Average MPH: 17.2
Average MPG: ~50*
*This calculation was determined by assuming 125000 BTU per gallon -> 131881982 joules per gallon.
Used 1000 N for 110 m = 110000 joules / .25 (eng. effiency) = 440000 joules
440000 joules / 131881982 joules per gallon = 0.00334 gallon
0.1677 miles / 0.00334 gallon = 50.2 MPG
NOTE: This does not take into account engine idle consumption because I do not know what my particular vehicle's consumption rate is. Nor do I worry about something so simple just yet in the calculations. I'm merely getting a grasp as to what it takes to iterate the best MPG in this situation...
Anyone know of some coding tools in Excel other than IF statements...? I'd rather do loops in a single cell and bundle the calculations.
CHECK OUT THE v. 1.1 below along with route1.
If it seems confusing, PLEASE ask questions and I'll explain.
|