There is a google spreadsheet:
[login to view URL]
The script is needed that fill 'recompute' table using initial values from 'init' table and values from sheets created by template.
Next algorithm could be used:
1) Function is inserted in the first cell of the recompute table and fills all of the range in table,
2) Number of the accounts could be changed, if it's possibe script could count number of accounts by iterating from current cell down to bottom of the page and stop counting when find a cell with some data. In example it will be at B15. Or constant could be created that will be reassigned when change number of accounts,
3) Each cell from range (in the example the range is B5: D14) fills by rules:
a) Initial value — for cell B5 it's G5, for С8 it's I8 etc.
b) plus all operations from sheets that starts from date that contains in H1 cell. Function that iterates over all necessary sheets is in the bottom of this description,
c) Each row from each sheet is added to appropriate cell according to right currency and right account.
As a result of the script I will have recomputed accounts that contains initial values and all operation from provided date.
// This code could be used to iterate over all necessary sheets.
// var sheets = [login to view URL] ().getSheets ();
// var sum = 0;
// var re = /.+\s[0–9]{4}$/
// var regExp = new RegExp (re);
// for (var i = 0; i < [login to view URL]; i++) {
// var sheet = sheets[i];
// if ([login to view URL] ().match (regExp)) {
// ......
// }
i took many courses in the Data entry,excel,Icdl,English (British council till level 12) &Bussiness managment that make me very qualified to make such this easy job before the time that will make you feel amazed by my skills and efficiency in doing such this jobs in data entry
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
4 freelancers están ofertando un promedio de $102 USD por este trabajo
Hello there, I will like to help you out with this project. I have plenty of experience developing codes on google spreadsheet so I know I can handle this task as you need it. Hope to hear back from you soon. Thanks.
Hello,
have done Google apps / spreadsheets work before. yes it is possible to go thru the cell and fetch the account, not a problem.
as you are already having detailed things to do clearly, it is ease to do the same as you wish without any problem. assuring you to provide best solution as per your request.
Looking forward to work with you.
Thanks,
Neethi