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 add 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. Currently only for CG loc. Others follows if needed
Post included in this report for column C must be entered in initial balance.
