TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker or making a Paypal contribution here: paypal.me/SupportTMC

Excel Spreadsheet for Miles and Charging Statistics?

Discussion in 'Model S: Driving Dynamics' started by CHGolferJim, Oct 23, 2015.

  1. CHGolferJim

    CHGolferJim Member

    Joined:
    Jan 28, 2014
    Messages:
    842
    Location:
    Chapel Hill, NC
    Anyone have a spreadsheet they could share so I can avoid reinventing the wheel? Or is there an app you can refer that will let me do this? I want to gather data for segments to see how climate/rain affect mileage for future predictive value. Many thanks.
     
  2. capt601

    capt601 Vin02324

    Joined:
    Feb 22, 2011
    Messages:
    454
    Location:
    Mission Viejo, California, United States
    Maybe run a few trips using evtripplanner, print out the csv File, and see the differences? I do that on every trip and have a few saved. Might be a start.
     
  3. CHG-ON

    CHG-ON Still in love after all these miles

    Joined:
    Jun 24, 2014
    Messages:
    2,766
    Location:
    Santa Cruz Mountains, USA
    Check out Bjorn's videos. He has done many measurements. He's awesome.
     
  4. clintons

    clintons Member

    Joined:
    Jun 19, 2012
    Messages:
    30
    Location:
    NC
    Here's is one: Model S Energy LOG - Google Sheets
    Enter your data in Columns A through G. The other columns have formulas. You might also change one or more values on the Constants tab to suit your situation.
     

Share This Page