Hi :) Going with the line-by-line approach but with a fast twist. Each line has identical calculations with the result feeding into the next line and then having the same calculation repeated doesn't it? So it's something like C1 = A1 * B1
A2 = C1 B2 = B1 C2 = A2 * B2 A3 = C2 B3 = B1 C3 = A3 * B3 I suspect a tad more complexity and there is probably a - in there somewhere (such as A2 = A1 - C1), but again more complex but all kinda boiling down to something like that? So write out the first row and the 2nd one but in row 2 write A2 = C1 B2 = $B$1 C2 = A2 * B2 Now select all 3 cells in row 2 (or do them individually if there are extra columns in between). See the tiny black square down in the bottom-right corner of the 3 selected cells? When your mouse hoovers over that it changes shape. When it's the new shape drag all the way down the page until somewhere past the last row you need (around 300 ish). Then just delete the rows you don't need and maybe make the last row bold. Regards from Tom :) ________________________________ From: John Jason Jordan <[email protected]> To: LibreOffice <[email protected]> Sent: Tuesday, 8 October 2013, 17:46 Subject: [libreoffice-users] Calc - Amortization I use Writer daily, but practically never use Calc, so I am pretty helpless. Now I have a problem that calls for a spreadsheet; actually, a script or plug-in or something to Calc. The problem is that I need to calculate an amortization chart for a loan of regular payments with an odd number of months, where the interest is calculated monthly rather than on a daily basis. When the loan was first made the term was supposed to be 300 months, but the amount of the payment was miscalculated, so the borrower has been paying slightly more. Using an HP-12C (yes, I still have one, and it still works!) I find that it will amortize in slightly less than 299 months. In order to find the true balance at any given time a custom chart must be created. I tried online services, but they cannot handle a mess like this. I also tried Google Docs, but I can't find even basic help information, like how to write <balance> x 045 / 12, or how to make the expression do the calculation. I could do this manually in Calc, one row at a time (ugh!), but I was hoping that there existed a script or something that would set it up for me and do all the calculations. I tried the LO extensions web page, but couldn't find anything. Any ideas or suggestions? -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
