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 and becoming a Supporting Member. For more info: Support TMC

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:
    874
    Location:
    Chapel Hill, NC
    #1 CHGolferJim, Oct 23, 2015
    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:
    457
    Location:
    Mission Viejo, California, United States
    #2 capt601, Oct 24, 2015
    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:
    3,037
    Location:
    Santa Cruz Mountains, USA
    #3 CHG-ON, Oct 24, 2015
    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
    #4 clintons, Oct 24, 2015
    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.
     
(You must log in or sign up to post here.)

Share This Page

Toggle Width
Style
TMC 2016