write 2 scripts in google spreadsheets

I have a google docs spreadsheet that requires 2 separate scripts to be written.

(1) The first script requires a little more power than what the conditional formatting function allows. I need conditional formatting based on a calculation of two other cells value. For example, (all data in all cells is manually input) cell J4 has the following options for data "In" "any numeral". If cell J4 reads "In" I want the background of the cell to be white. If value of J4 is equal to H4-I4, for example H4 is "10" and I4 is "8", and J4 is "2" then I want the background of the cell to be green. If value of J4 is not equal to H4-I4, for example H4 is "10, I4 is"8" and J4 is "4" then I want the background of the cell to be red.

(2) The second script needs to automatically input a set of values into a cells dependent on multiple tests of different cells in another sheet. For example, the value of cell B4 in sheet "Greensheet" will depend on the following conditions:

In sheet "Greensheet" there are several pieces of data input. cell B1 is an employee's name "Sean". Cell A4 is date "7/29/2012". The value for cell B4 needs to look at the value of another sheet "Payroll" match the employee's name from sheet "Greensheet" cell B1 to the employee's name in sheet "Payroll" which will be anywhere in column D. After a match by name has been made, a match by date needs to be made. The date in sheet "greensheet" Cell A4 must match with the date, for the correct employee, in sheet "payroll" column A which will have a list of dates. After the match of employee and date has been made, then the value in sheet "payroll" that corresponds to that employee and date must be input into sheet "greensheet" value for B4.

This task of filling in values for sheet "greensheet" needs to be accomplished across 4 different values. This script needs to be applied to multiple sheets that will have different employee names and different ranges of dates.

The budget for this project is $100. Please submit your best price bid along with your level of expertise in google docs script writing. If you have any similar projects you have worked on please let me see some examples of your work.

You will be given access to the spreadsheet via google docs. We will work together on accomplishing the job and I am available to answer or clarify any details. Payment will be given upon completion and receipt of the scripts that will accomplish the task. Thank you for your attention.

Compétences : Excel, Script Install

en voir plus : writing sheets, writing in script, writing in names, writing dates, write names, spreadsheet script google, script sheets, scripts for google spreadsheets, scripts for google, script google spreadsheet, power writing examples, payroll spreadsheet example, payroll examples spreadsheet, payroll example excel, payroll calculation, google spreadsheets scripts, google spreadsheet script examples, google spreadsheet examples, google spreadsheet example, google scripts spreadsheet, google docs scripts, google. docs, excel spreadsheet expertise, excel payroll spreadsheet examples, docs. google

Concernant l'employeur :
( 1 commentaire ) Brooklyn, United States

Nº du projet : #2401040

7 freelance font une offre moyenne de $111 pour ce travail


We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(25 Commentaires)

Hello, i can do this in a timely, accurate and professional manner look to work with you At your disposal for any query. Regards softwarevamp

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)

Hi, I am expert in spreadsheet scripting, please check inbox for more details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)

Hello. More 15 years vba, vb, office experience. See pmb with working example.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)

I have great experience with excel and VBA coding. I am very interested in helping you on this project.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Hi, I have been working for more than 6 years since now in the Excel and VBA, also created and implemented n number of tools in excel spreadsheets. I have also did the similar kind of project in my current concern as Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

i assureiwill it deliver timely

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)