Copy formulas in columns
| Source balance |
Source balance for copyng formulas |
| Dest. Balance |
Destination balance for copyng formulas. Program will copy only lines with the same line number |
| Source formula |
Source column for copying formula (1-10) |
| Destination formula |
Destination column for copying formula from source. |
| Copy formulas unchanged |
Mean, that program will copy formulas and just and calculation for column C. Letter A will be replaced with letter C for third column
|
| Copy formulas and add prefix for intial date calculation |
Similar to previus but also all formulas get prefix X
|
Practical use of prefix X for formulas. Program takes into account only posts from initial balance on that specific date colored yelow for comparative period in my case 01 01 2007 n my case (picture below). On report anValue3 must be entered for Column C and report must be ''flaged' in procedure to use this date. Some reports for some localisation are predefined already.
Post included in this report for column C must be entered in initial balance.
