Write A formula into write cell activity

Help Studio
, ,
1

Hello,

I’m trying to write a formula into excel to Calculate Distance for multiple locations, the formula is as below:
=ACOS(SIN(H3)*SIN(D3)+COS(H3)*COS(D3)*COS( (E3,I3)) *6371
I was able to write the formula for each row but I have 83.000 records so it throws an error as below:
job stopped with an unexpected exit code: 0xe0434352

So I tried another solution is to write the formula into a Cell then use Auto Fill range Activity
But it didn’t work it throws another error as below:
if your data is a formula, make sure you use comma as parameters separator.

Can Anyone Help me how to write the formula into the column G for al the 83.000 rows I have.

2

Hi ,

Kindly check your formula, It is showing error while manually typing the text in excel.

3

you can try using this way.

  1. prepare a template excel file containing your formula in the column G.
  2. use write range activity to add data with range A:H
  3. use autofill activity to fill that formula at all records.

Cheers,
Indra

4

Hi Priyanka,

Please Find the correct Formula Below:
=ACOS(SIN(H3)*SIN(D3)+COS(H3)*COS(D3)*COS( (E3-I3)) *6371

5

Hi @Karam_Abulawi ,

I’m still getting error can you provide sample file.