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.
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.
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
I have great experience with excel and VBA coding. I am very interested in helping you on this project.
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