2006 Model Year Prius Calculator

Discussion in 'The File Library' started by Kiloran, Nov 15, 2005.

  1. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    Version 4 now available.
    -Removed comparisons with 2005
    -Resolved estimated values
    -Made some column headers more descriptive
    -Various small formatting changes

    ======
    I am looking forward to incorporating feedback from PC members.
    I'll wait a day or two for suggestions to come in then I'll look into releasing version 2.

    Please be sure to check my math. :p

    ======
    2006_MY_Prius_Calculator_by_Kiloran___Version_2.xls ( 45.5k ) Number of downloads: 239
    2006_MY_Prius_Calculator_by_Kiloran___Version_3.xls ( 45.5k ) Number of downloads: 630

    11-15-2005 Replaced file with Version 2
    12-01-2005 Replaced file with Version 3
    02-16-2006 Edited for content. File temporarily unavailable28-April-2006 Version 3.0 restored.
    05-09-2006 Replaced file with Version 4

    Remember, the price of use is constructive criticism or praise. B)
     
  2. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    Oops!
    Some idiot forgot to attach the file! :p
     
  3. p626808

    p626808 New Member

    Joined:
    Mar 10, 2004
    292
    14
    0
    Location:
    NJ
    Vehicle:
    2010 Prius
    Model:
    V

    Looks good to me.. :D
    very nice..
     
  4. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    :D Thanks, Dood!
     
  5. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    Replaced file with Version 2

    Base price MSRP had incorrect value:
    was: $21,775
    corrected to: $21,725
     
  6. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    Edit: Edited for content.
     
  7. Krash

    Krash Junior Member

    Joined:
    Oct 16, 2005
    15
    0
    0
    Location:
    Tucson, AZ
    Kiloran

    Great work!
    It seems however that D48 needs to include all the Dealer Doc fees.
    Shouldn't C37 be the sum of C38:C43?

    Krash
     
  8. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    I believe it does.
    From D48:
    =IF(ISNUMBER(B48),(C48*(1 + $C$35) + $C$37), "")
    $C$37 contains the Dealer Document Fees.
    It is a total amount since that is usually how the dealer presents it (often to hide the fact that he's padding it with dealer profit)

    No, these values represent what the dealer must pay the state for these services.
    The sample values are for Pennsylvania.
    Another state would have different values.
    Applicable values may be selected as applicable by entering a "Y" in the appropriate cells within D38:D43.

    The dealer profit (C45) is the amount the dealer charges for documents ($C$37) minus the sum of what he must pay the state for those items selected in column
    D38:D43 (E44).

    Thanks for checking!
    Feel free to post or PM additional questions. B)
     
  9. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    Replaced file with Version 3
    Added MSRP and available Invoice prices for a-la-carte options.
    B)
     
  10. malibuman

    malibuman New Member

    Joined:
    Dec 21, 2005
    1
    0
    0
    Kiloran, this is excellent! I'm in the market now and will be purchasing at the first of the year. Thanks!
     
  11. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    I'm happy to see folks getting use out of this.
    I get to see the download count but that doesn't really tell you whether people are just looking at it or actually finding it useful.
    Thanks! B)
     
  12. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    Just ping-ing this thread to keep it active. B)
     
  13. derlmiller

    derlmiller New Member

    Joined:
    Jan 8, 2006
    7
    0
    0
    Has anyone used these numbers directly at a dealership? I'm curious if they might ask what the source is.

    Thanks,
    Derl

    Portland, Oregon
     
  14. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    The dealers already know these numbers and I doubt they'd risk challenging information they know is correct.

    FYI, the most of the numbers come from Edmunds.com. B)
     
  15. derlmiller

    derlmiller New Member

    Joined:
    Jan 8, 2006
    7
    0
    0

    OK thanks. Ya, I know that dealers have all of the invoices. As I understand it though, they aren't required to show them to you if you ask. Knowing that they come from Edmunds helps. I've bought two vehicles using an invoice as leverage. One invoice I bought off the internet, the other I pursuaded the salesman to show it to me. Just didn't want to show up with these numbers not knowing that they came from a reliable source.

    If I am able to get a good discount when I buy, I'll plan on making a donation to priuschat.
     
  16. Danny

    Danny Admin/Founder
    Staff Member

    Joined:
    Nov 24, 2003
    7,018
    1,847
    1,174
    Location:
    Charlotte, NC
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    Hey Kiloran - when are you going to put back up the calculator spreadsheets?
     
  17. ghostofjk

    ghostofjk New Member

    Joined:
    Mar 8, 2006
    979
    4
    0
    Gee, that took a long time, eh? :p
     
  18. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    <div class='quotetop'>QUOTE(Danny @ Apr 28 2006, 12:00 AM) [snapback]246466[/snapback]</div>
    Done and done (2005 and 2006).


    The price of use is constructive criticism or unqualified praise. B)
     
  19. Danny

    Danny Admin/Founder
    Staff Member

    Joined:
    Nov 24, 2003
    7,018
    1,847
    1,174
    Location:
    Charlotte, NC
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
  20. Kiloran

    Kiloran New Member

    Joined:
    Aug 31, 2005
    1,225
    0
    0
    <div class='quotetop'>QUOTE(Danny @ Apr 28 2006, 10:10 AM) [snapback]246613[/snapback]</div>
    No, I don't mind. It's very cool, in fact. :)

    I noticed some small clipping/wrapping issues that we might want to address.
    It looks like the horizontal scroll bar could probably be eliminated by making it slightly wider.

    Also, I'll see what I can do about updating the orange and pink cells:
    (Orange indicates that these values are not yet available and are assumed to be available and to not have changed in price since last year.
    Pink indicates a cell with an estimate based on average markup for a value which is not yet available.
    )


    For some reason, 2005 Model Year Prius Calculator doesn't show up in the "Similar topics" list.
     
Loading...