Ubuntu
example-content package

payment schedule

Bug #72499 reported by Shawn Collins on 2006-11-20

Affects		Status	Importance	Assigned to
	example-content (Ubuntu)	Fix Released	Undecided	Unassigned
Declined for Breezy by Colin Watson
Declined for Dapper by Colin Watson
Declined for Edgy by Colin Watson
Declined for Feisty by Colin Watson
Declined for Gutsy by Colin Watson

Bug Description

There is a formula enhancement that will more accurately portray what the total out-of-pocket is. Also, the 'Print' worksheet could simply reference the 'Amortization Schedule' instead of doing full recalcs on both worksheets.

Related branches

lp:ubuntu/karmic/example-content

Revision history for this message

Shawn Collins (shawncollins) wrote on 2006-11-20:

Corrects/enhances cell formulas Edit (75.0 KiB, application/vnd.oasis.opendocument.spreadsheet)

I've attached a new payment schedule as new-payment-schedule.ods, to reflect my thoughts on the formula enhancements. It correctly shows only principle and extra principle as the loan nears end-of-life.

Revision history for this message

lymz (dragos-neagu) wrote on 2007-05-03:

Shawn,

Can we get a list of these enhancements?

Revision history for this message

lymz (dragos-neagu) wrote on 2007-05-04:

new-payment-schedule.ods Edit (74.8 KiB, text/plain)

After examining it, I noted 2 formula "enhancements"; please feel free to add or elaborate on them. Also, "Principle" should be "Principal" as noted and fixed in bug #67991.

1. "Total Payments Paid" formula changed from:
"Interest" sum + "Loan Amount" + "Extra Principal" sum
to:
"Interest" sum + "Principal" sum + "Extra Principal" sum

2. "Extra Principal" formula (E13:E371) changed from:
IF("Balance" = 0); then $0; else "Extra Principal Payment"
to:
IF("Balance"=0); then $0; else IF ("Balance" + "Interest" - "Principal" >= "Extra Principal Payment"); then "Extra Principal Payment"; else "Balance" + "Interest" - "Principal"

I think both of these are more than just enhancements, these are bug fixes. If you enter a large amount for "Extra Principal Payment"(i.e. $50,000) both of these bugs are pretty evident; your "Total Payments Paid" would be incorrect and you would overpay in "Extra Principal".

There is still a bug in the spreadsheet; currently it is possible to overpay the loan in one period (i.e. enter an "Extra Principal Payment" larger than "Loan Amount" and you will get a negative balance). To fix this, just extend the formulas from E13:F13 to E12:F12.

I attached a spreadsheet with this minor fix and the correct spelling. I like the references from the "Print" worksheet instead of recalculating. Very good work!

Revision history for this message

Shawn Collins (shawncollins) wrote on 2007-05-24:

You caught exactly what I was getting at. Thanks for the effort on your end. Also, nice job cross-referencing to catch the spelling bug. I wasn't looking for that.

Revision history for this message

Colin Watson (cjwatson) wrote on 2007-11-22:

I'm declining the stable release nominations on this bug, since it doesn't meet the requirements for stable updates (https://wiki.ubuntu.com/StableReleaseUpdates).

Revision history for this message

Shawn Collins (shawncollins) wrote on 2007-11-23:

Whatever... You've got two separate attachments that resolve the issue. I'm sorry you don't have what you want. Maybe you should dumb down the Stable Release requirements as I can't figure out what you need. Keep a buggy spreadsheet available if that's what you want (linux) converts to work with... out of the box... in an examples directory.

Revision history for this message

Launchpad Janitor (janitor) wrote on 2008-03-07:

This bug was fixed in the package example-content - 27

---------------
example-content (27) hardy; urgency=low

  * debian/control: change branch to ~ubuntu-art-pkg
  * kubuntu-leaflet.png: Jonathan Patrick Davies corrected local websites and
    Changed "Linux" to "GNU/Linux". (LP: #163599)
  * oo-payment-schedule.ods: Shawn Collins and lymz fixed up the formulas and
    spelling mistakes (LP: #72499)
  * oo-cd-cover.odg: Phil Bull updated and fixed the text for 8.04.
    (LP: #179297)
  * debian/control: bumped Standards-Version, moved Homepage to its own field.

-- Daniel Holbach <email address hidden> Fri, 07 Mar 2008 11:20:14 +0100