Build script for google spreadsheets.

In Progress Posted Jul 9, 2015 Paid on delivery
In Progress Paid on delivery

There is a google spreadsheet:

[url removed, login to view]

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 = [url removed, login to view] ().getSheets ();

// var sum = 0;

// var re = /.+\s[0–9]{4}$/

// var regExp = new RegExp (re);

// for (var i = 0; i < [url removed, login to view]; i++) {

// var sheet = sheets[i];

// if ([url removed, login to view] ().match (regExp)) {

// ......

// }

Data Entry Data Processing Excel Google App Engine JavaScript

Project ID: #8035419

About the project

4 proposals Remote project Active Jul 9, 2015

Awarded to:

omohsen050

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 More

$10 USD in 1 day
(0 Reviews)
0.0

4 freelancers are bidding on average $102 for this job

DanielVizcaya91

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.

$198 USD in 3 days
(24 Reviews)
5.4
neethe

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 More

$175 USD in 3 days
(9 Reviews)
5.1
rs1rashed2

A proposal has not yet been provided

$25 USD in 2 days
(0 Reviews)
0.0