
AutoMate Discussion 
help :
faq :
home


Latest News:

latest topics : statistics 
Topic Title: Distance Calculation Topic Summary: Trying to calculate the distance between two points Created On: 09/12/2017 08:53 AM Status: Read Only 
Linear : Threading : Single : Branch 
Search Topic

Topic Tools

09/12/2017 08:53 AM


In excel I can calculate the distance between two points using a function, but I would like to replicate this same formula in Automate. This is the formula used in Excel: =ACOS(SIN(Lat1)*SIN(Lat2) +COS(Lat1)*COS(Lat2)*COS(Lon2Lon1)) *6371 I know Automate has the ability to perform math formulas, but I can't seem to figure it out. Can anyone please help?
Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) 



09/14/2017 06:59 AM


Hello JustinChugg,
The AutoMate Math group does not contain the ACOS, or inverse cosine, function. Our math group consists of Abs, Atn, Cos, Exp, Fix, Int, Log, Randomize, Rnd, Round, Sgn, Sin, Sqr, Tan. Your would need to construct this formula to use AutoMate for this calculation.
 Justin Aucoin  Support Analyst AutoMate  Division of HelpSystems HelpSystems, LLC  T: +1.213.738.1700  F: +1.213.738.7665 


AutoMate Discussion
» AUTOMATE » AutoMate 9
»
Distance Calculation

Topic Tools

FuseTalk Enterprise Edition v4.0  © 19992021 FuseTalk Inc. All rights reserved.