2006 Model Year Prius Calculator

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.

======
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)

 

Oops!
Some idiot forgot to attach the file!

 

Thanks, Dood!

 

Replaced file with Version 2

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

 

Edit: Edited for content.

 

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 D3843.

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
D3843 (E44).

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

 

Replaced file with Version 3
Added MSRP and available Invoice prices for a-la-carte options.
B)

 

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)

 

Just ping-ing this thread to keep it active. B)

 

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)

 

<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)

 

<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.