Sure, in the real world it is hard to sense slight altitude changes.You can be at 5,000 feet and still be pretty flat. But there are ALWAYS changes in grade. They may be imperceptible at times, but they are there. You can drive from Chicago to Denver and gain over 4,500 feet, and it is flat as hell.
You single data points don't provide any such information, and I was just showing you how there could easily be a large difference in energy usage with a small variable.
The real world example given here were for round trip over the same roads so any change would mostly be canceled out.
But you make assumptions when you did the Cybertruck towing 14,000 lbs will be 2,000 wh/mi
You did not inform the forum readers of all these caveats then.
What are all the assumptions you used?
More ad hominem attacks.I made no "assertion". I provided actual fucking math as to the energy required to move a 14,000 fifth wheel trailer of common size with a tow vehicle at sea level doing 55MPH with tires typical of those on pickup trucks.
Well you use less energy on some trips? Of course! Will you use more energy on some trips? Of course! Try educating yourself instead of arguing with science dude. Are you one of those people who doesn't wear a mask?
I could make similar attacks but I will let facts & science do the work.
You made all these assumptions when you used this supposedly fancy spreadsheet to do an estimate for the Cybertruck but now you say it is too difficult to make reasonable assumptions for real world examples that all forum readers have access too.
I guess forum readers should infer that the assumptions you used for the Cybertruck were not reasonable.
I am not disputing there will be some variances but you are the one that now throws out that there are all types of mitigating factors when your original 2,000 wh/mi answer did not mention any of them.Well you use less energy on some trips? Of course! Will you use more energy on some trips? Of course! Try educating yourself instead of arguing with science dude. Are you one of those people who doesn't wear a mask?
Your Cybertruck towing 14,000 2,000 wh/mi estimate is worthless since your spreadsheet does not give results close to typical real world trips without vetted & validated spreadsheet.
assumptions to use with Cybertruck towing 14,000lbs and other real world examples
steady speed 55 mph
altitude: sea level
level U.S. highway with normal speeds of 55-80mph (no hills, no mountains)
no stop & go traffic
moderate temp 70F
Are they other types of materially significant assumptions you made with Cybertruck towing 14,000 lbs 2,000 wh/ni estimate but did not tell us.
Here are some real world examples that would tell us about reliability of the spreadsheet
real world example 2
Tesla Model X LR+, 100 kwh, 5,421 lb (2,459 kg), 350 miles range
2018 Airsteam Bambi 22', 4,500lbs, 55mph, 489 wh/mi
real world example example 3
1. total weight: 11,000 lbs ( 4,990 kg )
--- (tow vehicle, 2 people (400lbs), bags (400lbs), misc stuff (120 lbs), trailer ( 6,000lbs)
2. Coefficient of drag for tow vehicle: 0.25
3. Coefficient of drag for trailer: 0.55
4. area of front of tow vehicle: 25 square ft ( 2.31 sq meters )
5. area of front of trailer: 76.5 sq ft ( 7.124 sq meters = 2.60m x 2.74m)
6. speed: 56 mph ( 90 k/h )
real world example 4
2017 Ford F-350 Gross weight 9900 lbs 15-17 mpg, 8-10 mpg towing ( 50% loss when towing)
2019 Grand Design Reflection 312BHTS 37ft GVWR 11,295 trailer
Height 11' 8" ( 3,556 mm )
Width 8' ( 2,438 mm )
I suspect you will not give us answers to these real world examples because the answer would show your spreadsheet does not work.
A spreadsheet that does not provide entire source so it can be vetted and is not validated against real work examples is worthless.