Sheets also has some very useful functions for pulling in data from the web. For example,
=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_U.S._states_by_population_density","table",1)will pull in data about population density by state from Wikipedia. The last argument is simply an index for the table on the target page that you want to grab; you can use trial and error to find the right index on pages with crazy table formatting.
https://www.google.com/fusiontables/DataSource?docid=11sHQwVRy17GkKd4SnamR8ewCqKd74gyAW38T52c#rows:id=1into the text entry at the bottom of the page. The next dialog asks you to select the keys for joining the data, be sure to select the 2-letter state abbreviations for both files. You can also choose which columns to include or exclude. You need the Geometry column from the merged table, for sure.
It’s been a cold winter here in the eastern US. But the rest of the world, not so much-
I drove the 4 miles to work today, using 0.8 kWh in the process. That’s 5 miles per kWh.
This was better than average (in cold weather, I think I’m closer to 3 miles per kWh).
I am curious about how CO2 emissions emissions for this car stack up to a normal hybrid. I know that here in New England, as of 2011 the marginal CO2 emissions for electricity was 0.91 lbs CO2 / kWh generated (down from 1.1 in 2005).
I’m not going to worry about distribution & charging losses just yet, though they should make some difference. Using 5 miles per kWh, and 0.91 lbs CO2 / kWh, yields 0.18 lbs CO2 per mile, which is pretty good.
Gasoline produces about 19 lbs CO2 per gallon burned. I believe, but need to verify, that this figure excludes the upstream emissions of refining, etc., so the actual marginal number would be higher. But let’s stick with 19 lbs/gallon for now. To get the same CO2 emissions as I got this morning, my car would have to get 19 / 0.18 = 105 mpg. That’s tough to get in a conventional car, hybrid or not, even under ideal conditions.
I think on average I get more like 3 miles / kWh. That works out to 0.30 lbs CO2 per mile. The equivalent gasoline-only vehicle would have to get 19 / 0.30 = 63 mpg. For reference, Prius drivers typically get 48 mpg, while the Prius V (which is closer in size to my car) gets about 42 mpg, real world.
Bottom line- my Fusion Energi, in pure electric mode, has CO2 emissions that non-plug-in vehicles can’t really match.
I’ll sharpen the pencil as time goes on (and double-check that I’m not, for example, confusing lbs C with CO2).
This is my plug-in Fusion. I got a good deal on a lease. I am learning a lot about life with a partially electric vehicle; more to follow!
On the to do list (via Antarctic Explorers & Emperors | Antarctica | OutsideOnline.com)
I love the dog’s expressions in these (via Man re-enacts romantic movie scenes with his boss’s dog [18 pictures] | 22 Words)
A clever idea, if a little wacky-
(via Your life in jellybeans)
The tragedy graph (via Want to Save Lives? You Need a Map of What’s Doing Us In - Wired Science)
Executive summary of this year’s Red Sox: Skill, hustle and great team chemistry.