Simple (web?) application for producing something like a bank statement - ideas?

[william drescher]

On 6/13/2012 5:38 AM, Chris Green wrote:
>>
>> a spreadsheet is probably the best solution.  If you enter the formula
>> in the top cell of the running balance column yoiu can use the drag
>> handle to automatically enter the appropriate formula in all the cells
>> below it; you don't need to enter the formula in each cell manually.
>>
> But the cells aren't there below it until the 'next line' has been entered.
>
> I don't want a huge table of emptiness with just a few rows and columns
> with data in them (as seems to be the norm with most Spreadsheet use I
> have seen).
>
> When there are (say) eight debit/credit entries in my table I just want
> to see eight rows in the spreadsheet with (probably) just three or four
> columns.
>
> If I understand you correctly you are saying one should copy the formula
> for the running balance into the Balance column for lots of columns into
> the future - is this right?
>
> Another issue is that the formula is *different* for the running balance
> as you go down isn't it as it's the sum of all rows up to and including
> the current row and the current row changes as you go down the table.  I
> seem to remember there isn't an easy way to code this in most
> spreadsheets.
>
You can set up your spreadsheet with x data rows (each of which 
has a running balance) and a total row(basically a placeholder).
Set the running balance cells to add the transaction amount for 
that row to the running balance of the prior row.

When you need to add a new data row, insert it just above the 
total row and LO and OO will adjust the totals of the total row 
and (I think - untested) copy the formulas from the prior row, 
thus keeping the running balance correct.

bill