I need a google sheets script that makes the following for every existing record in a spreadsheet:
1) Takes a set of columns as inputs in the Original Sheet (Let's say we have A1= 65, B1= 1.65, C1= John, A2= 85, B2= 1.83, C2=Michael, etc. )
2) These inputs are copied into different cells in another Sheet where there is sequence of static calculations that throw one or more outputs. These calculations can't be moved, edited, neither make the formula expanded into other cells... they just take a fixed input list, and throw a fixed output(s) result. (ie. in another sheet the inputs need to be copied in S100:S101, and the output (4 outputs) is calculated in Z7:Z10.
3) These 4 outputs are now added in the next columns of the original Sheet for every according record. (For John, it would be in D1:G1... and for Michael it would be in D2:G2, and so on)
Extra (to be discussed / negotiated):
- Can we add the result of URL's containing web forms also? (As an example URL1 a BMI Calculator like [url removed, login to view], and URL2 a Weight on the Moon Calculator like [url removed, login to view])
- The according outputs of each Calculator would be added in the next available columns (H1= result1_for_John, I1= result2_for_John, H2=result1_for_Michael, I2= result2_for_Michael, etc.)
[url removed, login to view]
14 freelancers are bidding on average $1908 for this job
I have done several projects with GSuite (Spreadsheets, Calendar, Form, etc.). This skills are "mainstream" in my freelance activity. I would like to improve them and achive high quality in every project.
Hello, I have read the description of the project and I am interested in working on this project. Please send a message so that we can discuss the project exclusively.
We are a team of computer Professions/expert. We have a lot of experience of similar types of job. We are available all the 24 hours and we are dedicated to hard work, accuracy and punctuality.