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 [login to view URL], and URL2 a Weight on the Moon Calculator like [login to view URL])
- 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.)
[login to view URL]
13 freelancer đang chào giá trung bình $1876 cho công việc này
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.
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.