THANKS MorrisonHiker, I also found the gas price entered wrong for New Hampshire. The corrected spreadsheet is below.
I added all the states to compare the fuel cost between Tesla's 100 kWh battery and a Prius that gets 50 miles to a gallon. There are sixteen states where the electricity cost for the Tesla is greater than the cost of gas for a Prius getting 50 miles to the gallon. The comparison gets better for Tesla as the cost of gas goes up and when driving a ice vehicle that gets less than 50 miles to a gallon.
I think this supports Tesla charging an average 12 cents a kWh for all states used in their current charging estimator to determine charging cost per mile.
Link to current cost of a kWh of electricity by state:
www.electricchoice.com/electricity-prices-by-state/
Link to the current average price of regular gas by state:
www.gasprices.aaa.com/
View attachment 192463