Suoritettu

Google spreadsheet script functions (2)

Very simple project...

I need two Google spreadsheet script functions that can be called from the cell of one worksheet to access data in the table of another sheet.

The script functions include...

1) Function – LookupRow(ColName, WorkSheetName, row)

a. Return the last value in the last row for a column by column name or column letter in given worksheet. Optionally, return the value in the previous or following row(s). Example -1 or +1 or any other value. Return valid date (if row cannot be found) return 0.

2) Function – LookupRowDate(ColName, WorkSheetName, date, row)

a. Return the value in the cell in a specific column for a specific row by date found in column A. Optionally, return the value in the previous or following row(s). Example -1 or +1 or any other value. Return valid date (if row cannot be found) return 0.

Sample data is provided in the attached file but will actually reside in a Google spreadsheet document. Please provide a sample of similar work so that I know that you can actually do this job.

Taidot: C# -ohjelmointi, Google App Engine, Javascript

Näytä lisää: spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, spreadsheet google functions, spreadsheet functions google, script programming, script google spreadsheet, programming functions, job spreadsheet, job letter sample, google spreadsheet example, google programming, functions programming, functions in programming, function sheet sample, example of a job letter, example letter job, c sharp job, google spreadsheet valid data script

Tietoa työnantajasta:
( 14 arvostelua ) Woodinville, United States

Projektin tunnus: #1127920

Myönnetty käyttäjälle:

AlexMDumitru

Please, check your PMB.

$200 USD 2 päivässä
(6 Arvostelua)
4.8

5 freelanceria on tarjonnut keskimäärin 186$ tähän työhön

sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lisää

$250 USD 5 päivässä
(18 arvostelua)
5.9
richb38

Hi, I can get to this early next week.

$180 USD 7 päivässä
(1 arvostelu)
2.4
manojdotnet

Hi, I am interested to work on this project . Please find more details in your PMB. Thanks, Manoj.

$200 USD 7 päivässä
(0 arvostelua)
0.0
up2date

Sir this is vary simple problem . i can do this ,

$100 USD 3 päivässä
(0 arvostelua)
0.0