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

RWD/AWD/AWD-P Power - Excel Silliness

Discussion in 'Model 3' started by spesler, Jul 24, 2018.

  1. spesler

    spesler Member

    Joined:
    Jul 6, 2018
    Messages:
    262
    Location:
    Atlanta, GA USA
    There are several different sets of numbers floating around regarding the comparative power of the three currently produced versions of the Model 3.

    Among these are:

    Inverter Size (primarily reddit/forum "experts")
    RWD - 800W rear
    AWD - 500W rear and 500W front (1000W total)
    AWD-P - 800W rear and 500 W front (1300W total)

    HP (autoweek and other professional first drive reviews)
    RWD - 271 hp
    AWD - 346 hp
    AWD-P - 450 hp

    0-60 times (Tesla)
    RWD - 5.1s
    AWD - 4.5s
    AWD-P - 3.5s

    There is also the motor power (and resulting calculated hp) listed by the EPA, but the huge jump of the AWD compared to the RWD, and the tiny difference between AWD and AWD-P really doesn't align with any other source of data.

    Soo.. given that I am still likely months away from getting my car, and having nothing better to do, I dumped them all into excel to see how well the numbers agree with each other. There are all kinds of problems with my analysis, so I would never throw around words like "scientific" or "rigorous", but it feels about right for sitting on the sofa in front of the TV.

    First, I created a table with all of the information, and added curb weights to calculate a power-to-weight ratio (based on the "autoweek" hp numbers). Then, I broke out two smaller tables, each with the data normalized to the RWD values so I could easily graph them. Each of the two smaller tables gets a graph.

    The first small table compares the reported hp to the idea that the RWD and AWD-P have the same rear inverter, the AWD and AWD-P have the same front inverter, and the AWD has a smaller rear inverter. Without breaking out r-squared values or other things that people who wear glasses understand, I'd say that they look pretty close! The two data sources do not contradict each other.

    The second small table compares the inverse of 0-60 times to power-to-weight ratios. Are these units even comparable? Who knows. But the bars cluster together pretty nicely - if anything they make the dual motor cars look like they are sandbagging a few tenths.

    In summary, I'm bored. Where is my car?
     

    Attached Files:

    • Helpful x 1
    • Like x 1
  2. P85_DA

    P85_DA Supporting Member

    Joined:
    Apr 25, 2015
    Messages:
    2,881
    Location:
    CA
    Lol good job ...u must be really bored waiting ;)
     
    • Love x 1
  3. spesler

    spesler Member

    Joined:
    Jul 6, 2018
    Messages:
    262
    Location:
    Atlanta, GA USA
    Bored and constantly reminding myself that we do not have an extra $11k laying around to buy my car an underline!
     
    • Love x 1
  4. quantumslip

    quantumslip Member

    Joined:
    Mar 3, 2015
    Messages:
    255
    Location:
    Houston, TX
    Your units are wrong for the inverter. I think you meant to use amps.
     
    • Informative x 1
    • Like x 1
  5. spesler

    spesler Member

    Joined:
    Jul 6, 2018
    Messages:
    262
    Location:
    Atlanta, GA USA
    #5 spesler, Jul 24, 2018
    Last edited: Jul 24, 2018
    Agreed. Luckily voltage is a constant so should still be fair to compare to hp.
     
  6. D3xDt3Reaction

    Joined:
    Dec 2, 2017
    Messages:
    308
    Location:
    Arizona
    Interesting that if you divide the RWD 0-60 of 5.1 by your 1.55 HP/Weight factor you get ~3.3s, which is what Elon said the P might do with stickier tires.
     
  7. Sonic86

    Sonic86 Member

    Joined:
    Mar 2, 2018
    Messages:
    16
    Location:
    Ireland
    Looks great and all but what power will the AWD-P be making at higher speeds

    RWD is making 271bhp at 40mph, but by 80mph its down to less than 240bhp

    AWD-P rival like a BMW M3 will make 440bhp at 140mph

    AWD-P is probably down from 450bhp to less than 350bhp at 140mph

    Will get its ass spanked on the track if that's the case
     
  8. PhaseWhite

    PhaseWhite Member

    Joined:
    Aug 12, 2017
    Messages:
    312
    Location:
    Minneapolis,MN
    I think it depends on the track since the P3D will have the major torque advantage coming out of each turn.
     
    • Like x 1

Share This Page

  • About Us

    Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.
  • Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


    SUPPORT TMC