2006 Model Year Prius Calculator

Kiloran · 11-15-2005, 10:29 AM

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.xl s ( 45.5k ) Number of downloads: 239
2006_MY_Prius_Calculator_by_Kiloran___Version_3.xl s ( 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.

Kiloran · 11-15-2005, 10:43 AM

Oops!
Some idiot forgot to attach the file! :P

p626808 · 11-15-2005, 12:47 PM

Quote:

Originally posted by Kiloran@Nov 15 2005, 10:43 AM
Oops!
Some idiot forgot to attach the file! :P

[snapback]155834[/snapback]

Looks good to me..

very nice..

Kiloran · 11-15-2005, 01:20 PM

Quote:

Originally posted by p626808@Nov 15 2005, 01:47 PM
Looks good to me..
very nice..

[snapback]155881[/snapback]

Thanks, Dood!

Kiloran · 11-15-2005, 02:11 PM

Replaced file with Version 2

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

Kiloran · 11-18-2005, 09:12 AM

Edit: Edited for content.

Krash · 11-18-2005, 01:51 PM

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

Kiloran · 11-18-2005, 02:21 PM

Quote:

Originally posted by Krash+Nov 18 2005, 02:51 PM--><div class='quotetop'>QUOTE(Krash @ Nov 18 2005, 02:51 PM)</div>

Quote:

Great work!

[snapback]157660[/snapback]
[/b]

Thanks!

<!--QuoteBegin-Krash@Nov 18 2005, 02:51 PM
It seems however that D48 needs to include all the Dealer Doc fees.

[snapback]157660[/snapback]

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)

Quote:

Originally posted by Krash@Nov 18 2005, 02:51 PM
Shouldn't C37 be the sum of C38:C43?

[snapback]157660[/snapback]

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

43.

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

43 (E44).

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

Kiloran · 12-01-2005, 10:20 AM

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

malibuman · 12-21-2005, 11:19 AM

Quote:

Originally posted by Kiloran@Dec 1 2005, 10:20 AM
Replaced file with Version 3
Added MSRP and available Invoice prices for a-la-carte options.

[snapback]165106[/snapback]

Kiloran, this is excellent! I'm in the market now and will be purchasing at the first of the year. Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
1/30 Scale model of 2006 Prius	TheForce	Gen II Prius Main Forum	28	10-02-2007 12:10 PM
Toyota Announces 2008 Model Year Prices for Prius, etc.	lmalchiodi	Prius and Hybrid News	12	08-01-2007 09:30 PM
Model year differences from 04	gravenstuk	Fred's House of Pancakes	6	11-25-2006 02:10 AM
2005 Model Year Prius Calculator	Kiloran	The File Library	15	04-26-2006 03:27 PM
Prius model 2006 test	andreaswin	Gen II Prius Main Forum	3	04-07-2006 10:43 PM

11-15-2005, 10:29 AM	#1
Kiloran Join Date: Aug 2005 Posts: 1,225 My Car: Model: Package: Thanks: 0 Thanked 0 Times in 0 Posts Friends: 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.xl s ( 45.5k ) Number of downloads: 239 2006_MY_Prius_Calculator_by_Kiloran___Version_3.xl s ( 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.

11-15-2005, 10:43 AM	#2
Kiloran Join Date: Aug 2005 Posts: 1,225 My Car: Model: Package: Thanks: 0 Thanked 0 Times in 0 Posts Friends: 0	Oops! Some idiot forgot to attach the file! :P

11-15-2005, 02:11 PM	#5
Kiloran Join Date: Aug 2005 Posts: 1,225 My Car: Model: Package: Thanks: 0 Thanked 0 Times in 0 Posts Friends: 0	Replaced file with Version 2 Base price MSRP had incorrect value: was: $21,775 corrected to: $21,725

11-18-2005, 09:12 AM	#6
Kiloran Join Date: Aug 2005 Posts: 1,225 My Car: Model: Package: Thanks: 0 Thanked 0 Times in 0 Posts Friends: 0	Edit: Edited for content.

11-18-2005, 01:51 PM	#7
Krash Join Date: Oct 2005 Location: Tucson, AZ Posts: 15 My Car: Model: Package: Thanks: 0 Thanked 0 Times in 0 Posts Friends: 0	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

12-01-2005, 10:20 AM	#9
Kiloran Join Date: Aug 2005 Posts: 1,225 My Car: Model: Package: Thanks: 0 Thanked 0 Times in 0 Posts Friends: 0	Replaced file with Version 3 Added MSRP and available Invoice prices for a-la-carte options.