Sponsored Content
Full Discussion: Formula help
Top Forums UNIX for Dummies Questions & Answers Formula help Post 302179393 by bobo on Thursday 27th of March 2008 03:14:51 PM
Old 03-27-2008
Data Formula help

The formula below will calculate a distance in miles between 2 points in excel. Can some put it to work in unix?

Lat = 43.335
Lon1 = -70.9884

Lat2 = 43.4829
Lon2 = -71.246

distance =3444*ACOS(COS(RADIANS(90-(Lat)))*COS(RADIANS(90-(Lat2)))+SIN(RADIANS(90-(Lat1)))*SIN(RADIANS(90-(Lat2)))*COS(RADIANS((Lon1-Lon2))))

distance = 14.3376283 miles
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Quadratic Formula Program

I have a question about the program I am making. I finished it, compiled it, and there were no errors. Now when I run it, the comand prompt comes up and there are just 1's and 0's that keep looping over and over again. The program is listed before. If anyone has any suggestions I would greatly... (2 Replies)
Discussion started by: zeek
2 Replies

2. Shell Programming and Scripting

Help with formula in a script

I need some help. I been doing system admin for the last several years and gotten very rusty on scripting. I need to write a script that will take a log entry and do math using two columns of data to create a new column. I am taking the column(#2) that contains the time and the column(#5) that... (3 Replies)
Discussion started by: scottzx7rr
3 Replies

3. Solaris

formula to get the swap space on a machine

Hello there are different opinions on how to get the swap space on Solaris. some say: swap -s and the space= used + available others say swap -l (donno how they get the swap size) other say 'top' command others say using format command (in print sub-command) Could you please advise on... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

4. Shell Programming and Scripting

how to create script for this formula?

Hello Unix gurus, Can anyone tell me the most efficient way to create script for the formula? Formula: Ans = 1 - ((Buffer pool data physical reads + Buffer pool xda physical reads + Buffer pool index physical reads + Buffer pool temporary data physical reads + Buffer pool temporary xda... (6 Replies)
Discussion started by: Rahulpict
6 Replies

5. Shell Programming and Scripting

Formula to get combination… sum

Formula to get combination Lats say, I have 5 values ID Price 1 5 2 10 3 30 4 5 Resule with Possible combinations will be ID Price 1 5 2 10 3 30 4 5 1+1 10 1+2 15 1+3 35 1+4 10 (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies

6. Shell Programming and Scripting

Convert Formula to Value

I'm new to Perl, but I need to use it to write into an excel spreadsheet. I want to copy the values of certain cells into a new sheet in the workbook. I'm unsure of how to do this because I don't know how to copy values instead of formulas. Note: by formula I mean '=SUM(A1,A2)' and by value I... (0 Replies)
Discussion started by: AgentSmith88
0 Replies

7. Shell Programming and Scripting

formula missing in excel after using perl

Dear all, I got a template excel file which contains several worksheets. Each worksheet contains some formulas in the cells. I am using the perl script to read a CSV file and then put the data of CSV into template excel file(first worksheet) and then save it as new file name using ... (0 Replies)
Discussion started by: eldonlck
0 Replies

8. Shell Programming and Scripting

Formula missing in excel after using perl

Hi all, I use "Spreadsheet::ParseExcel::SaveParser" to - read a existing excel file with : $Parser = Spreadsheet::ParseExcel::SaveParser->new(); $HeaderFile = $Parser->Parse("XLS_FILE_ACCESS"); - modify some values in somes cell with : $worksheet->AddCell($row_target,$col_max,... (3 Replies)
Discussion started by: Yom
3 Replies

9. Shell Programming and Scripting

A strange formula

Dear Masters, Kindly need your helps for this issue.. I face a formula as a picture... the input file is A DEPT Vp Vs rho VPperVS ------------------------ ------------ ------------ ------------ 700 151.9218 121.9269 ... (11 Replies)
Discussion started by: ipatah
11 Replies

10. Solaris

Formula calculate scan rate

Hi There, Just curious here... If there formula to calculate scan rate on solaris? Thanks Edy (3 Replies)
Discussion started by: edydsuranta
3 Replies
Geo::Distance::XS(3pm)					User Contributed Perl Documentation				    Geo::Distance::XS(3pm)

NAME
Geo::Distance::XS - speed up Geo::Distance SYNOPSIS
use Geo::Distance::XS; my $geo = Geo::Distance->new; my $distance = $geo->distance(mile => $lon1, $lat1 => $lon2, $lat2); DESCRIPTION
The "Geo::Distance::XS" module provides faster C implementations of the distance calculations found in "Geo::Distance". See the documentation for that module for usage. NOTE: As of version 0.13, Geo::Distance automatically uses this module if it is installed. FORMULAS
In addition to the formulas offered in "Geo::Distance", this module implements the additional formulas: alt: Andoyer-Lambert-Thomas Formula This is faster than the Vincenty formula, but trades a bit of accuracy. PERFORMANCE
This distribution contains a benchmarking script which compares "Geo::Distance::XS" with "Geo::Distance" and "GIS::Distance::Fast". These are the results on a MacBook 2GHz with Perl 5.14.2: ---- [ Formula: hsin ] ------------------------------------ perl - distance from LA to NY: 2443.08796228363 miles xs - distance from LA to NY: 2443.08796228363 miles gis_fast - distance from LA to NY: 2443.08796228363 miles Rate gis_fast perl xs gis_fast 24802/s -- -70% -98% perl 81919/s 230% -- -92% xs 1003704/s 3947% 1125% -- ---- [ Formula: tv ] ------------------------------------ perl - distance from LA to NY: 2448.24135235512 miles xs - distance from LA to NY: 2448.2413523656 miles gis_fast - distance from LA to NY: 2448.24135235512 miles Rate perl gis_fast xs perl 18101/s -- -19% -95% gis_fast 22330/s 23% -- -94% xs 345717/s 1810% 1448% -- ---- [ Formula: polar ] ------------------------------------ perl - distance from LA to NY: 2766.02509696782 miles xs - distance from LA to NY: 2766.02509696782 miles gis_fast - distance from LA to NY: 2766.02509696782 miles Rate gis_fast perl xs gis_fast 19200/s -- -78% -98% perl 87682/s 357% -- -93% xs 1214700/s 6227% 1285% -- ---- [ Formula: cos ] ------------------------------------ perl - distance from LA to NY: 2443.08796228363 miles xs - distance from LA to NY: 2443.08796228363 miles gis_fast - distance from LA to NY: 2443.08796228363 miles Rate gis_fast perl xs gis_fast 24435/s -- -69% -98% perl 78913/s 223% -- -93% xs 1147836/s 4597% 1355% -- ---- [ Formula: gcd ] ------------------------------------ perl - distance from LA to NY: 2443.08796228363 miles xs - distance from LA to NY: 2443.08796228363 miles gis_fast - distance from LA to NY: 2443.08796228363 miles Rate gis_fast perl xs gis_fast 18270/s -- -75% -98% perl 74472/s 308% -- -93% xs 1102769/s 5936% 1381% -- ---- [ Formula: mt ] ------------------------------------ perl - distance from LA to NY: 2443.08796228363 miles xs - distance from LA to NY: 2443.08796228363 miles gis_fast - distance from LA to NY: 2443.08796228363 miles Rate gis_fast perl xs gis_fast 17935/s -- -75% -98% perl 71739/s 300% -- -94% xs 1135525/s 6231% 1483% -- This distribution contains another benchmarking script which compares only the XS formulas over several different coordinates: Rate tv hsin alt cos mt gcd polar tv 16906/s -- -90% -90% -91% -91% -91% -92% hsin 165414/s 878% -- -4% -8% -10% -13% -17% alt 172032/s 918% 4% -- -5% -7% -9% -14% cos 180326/s 967% 9% 5% -- -2% -5% -10% mt 184357/s 991% 11% 7% 2% -- -3% -8% gcd 189253/s 1019% 14% 10% 5% 3% -- -6% polar 200386/s 1085% 21% 16% 11% 9% 6% -- Calculated length for short distance: alt : 40.3740136064528 miles cos : 40.3095459813536 miles gcd : 40.3095459813294 miles hsin : 40.3095459813294 miles mt : 40.3095459813536 miles polar: 46.7467797109043 miles tv : 40.3740136384531 miles Calculated length for long distance: alt : 2448.24135691376 miles cos : 2443.08796228363 miles gcd : 2443.08796228363 miles hsin : 2443.08796228363 miles mt : 2443.08796228363 miles polar: 2766.02509696782 miles tv : 2448.2413523656 miles Calculated length for nearly antipodes: alt : 12340.6455133245 miles cos : 12340.327635068 miles gcd : 12340.327635068 miles hsin : 12340.327635068 miles mt : 12340.327635068 miles polar: 12368.4764642469 miles tv : 12340.7483034002 miles Calculated length for antipodes: alt : 12429.86673988 miles cos : 219.005548031861 miles gcd : 12438.0476860875 miles hsin : 12438.0475680956 miles mt : 219.005548031861 miles polar: 12438.0476860875 miles tv : 12370.1885059814 miles Calculated length for polar antipodes: alt : 12429.86673988 miles cos : 12438.0476860875 miles gcd : 12438.0476860875 miles hsin : 12438.0476860875 miles mt : 12438.0476860875 miles polar: 12438.0476860875 miles tv : 12429.8667398787 miles SEE ALSO
Geo::Distance http://blogs.esri.com/esri/apl/2010/09/28/fast-times-at-geodesic-high/ <http://blogs.esri.com/esri/apl/2010/09/28/fast-times-at-geodesic- high/> REQUESTS AND BUGS
Please report any bugs or feature requests to http://rt.cpan.org/Public/Bug/Report.html?Queue=Geo-Distance-XS <http://rt.cpan.org/Public/Bug/Report.html?Queue=Geo-Distance-XS>. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes. SUPPORT
You can find documentation for this module with the perldoc command. perldoc Geo::Distance::XS You can also look for information at: o GitHub Source Repository http://github.com/gray/geo-distance-xs <http://github.com/gray/geo-distance-xs> o AnnoCPAN: Annotated CPAN documentation http://annocpan.org/dist/Geo-Distance-XS <http://annocpan.org/dist/Geo-Distance-XS> o CPAN Ratings http://cpanratings.perl.org/d/Geo-Distance-XS <http://cpanratings.perl.org/d/Geo-Distance-XS> o RT: CPAN's request tracker http://rt.cpan.org/Public/Dist/Display.html?Name=Geo-Distance-XS <http://rt.cpan.org/Public/Dist/Display.html?Name=Geo-Distance-XS> o Search CPAN http://search.cpan.org/dist/Geo-Distance-XS/ <http://search.cpan.org/dist/Geo-Distance-XS/> COPYRIGHT AND LICENSE
Copyright (C) 2009-2012 gray <gray at cpan.org>, all rights reserved. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
gray, <gray at cpan.org> perl v5.14.2 2012-04-14 Geo::Distance::XS(3pm)
All times are GMT -4. The time now is 05:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy