davidrools
03-17-2008, 06:08 PM
This one's for the geeks (I know who you are). I was bored at work last week and started putting together a spreadsheet to calculate relative efficiencies and costs of driving the Aptera vs. other vehicles. Feel free to take a look at the attached spreadsheet. I'm sure I've probably made some significant errors so feel free to correct. I should probably annotate to show my derivations, so I'll do that soon if anyone's interested.
There are two variables that I'm not sure how to estimate but have a pretty significant impact on the results. They are:
Aptera efficiency! How many watts does it take to drive a mile? This of course varies with driving behavior (cruising speed, hard acceleration, etc.) so I have three lines to bracket/center different scenarios. I calculated the ideal case based on the claimed 120 mile range using an 80% discharge of a 10kW battery (8,000W/120miles=67W/mi) with 100% drain getting a little worse 83.3W/mi. I also tried to back calculate the efficiency based on Aptera's claims of "$1 or $2 of electricity to charge overnight" which of course depends heavily on commute distance and driving style. Anyway, any ideas on that spec would be helpful.
Also, the charging efficiency may come into play since not all the juice you pay for will make it into the batteries. I'm sure its a relatively small loss, but it would surely add up over 10 years of nightly charging. I just don't have a clue as to what number to plug in there (100% eliminates the consideration all together)
Thanks!
In case you can't or don't want to bother unzipping/opening the Excel file, it basically lets you punch in the price of electricity and gas, lbs of CO2 produced from gas or electricity, mpg of cars to compare, and # of miles you drive in a week, then it outputs the weekly and monthly cost of operating each car, cost and CO2 savings over other cars, and equivalent mpg and gas price for the Aptera.
Here's a Google Doc (http://spreadsheets.google.com/ccc?key=pqbAfu8laph4aLj_HXZIPKg&hl=en) if you're into that thing :) (choose File -> "Copy Spreadsheet" to save it to your account and play with your own numbers!)
There are two variables that I'm not sure how to estimate but have a pretty significant impact on the results. They are:
Aptera efficiency! How many watts does it take to drive a mile? This of course varies with driving behavior (cruising speed, hard acceleration, etc.) so I have three lines to bracket/center different scenarios. I calculated the ideal case based on the claimed 120 mile range using an 80% discharge of a 10kW battery (8,000W/120miles=67W/mi) with 100% drain getting a little worse 83.3W/mi. I also tried to back calculate the efficiency based on Aptera's claims of "$1 or $2 of electricity to charge overnight" which of course depends heavily on commute distance and driving style. Anyway, any ideas on that spec would be helpful.
Also, the charging efficiency may come into play since not all the juice you pay for will make it into the batteries. I'm sure its a relatively small loss, but it would surely add up over 10 years of nightly charging. I just don't have a clue as to what number to plug in there (100% eliminates the consideration all together)
Thanks!
In case you can't or don't want to bother unzipping/opening the Excel file, it basically lets you punch in the price of electricity and gas, lbs of CO2 produced from gas or electricity, mpg of cars to compare, and # of miles you drive in a week, then it outputs the weekly and monthly cost of operating each car, cost and CO2 savings over other cars, and equivalent mpg and gas price for the Aptera.
Here's a Google Doc (http://spreadsheets.google.com/ccc?key=pqbAfu8laph4aLj_HXZIPKg&hl=en) if you're into that thing :) (choose File -> "Copy Spreadsheet" to save it to your account and play with your own numbers!)