03-27-2008
A quick detour via Google seems to suggest that the constant in the Excel formula is wrong, or at least debatable, it should be something like 3963 for miles, or 6378.8 for kilometers. Another source has 3959.98 for miles or 6372.797 for kilometers. Apparently, it (also) depends on how far from the equator you are.
See also
Unit 014 - Latitude and Longitude
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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
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
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
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
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
Hi There,
Just curious here...
If there formula to calculate scan rate on solaris?
Thanks
Edy (3 Replies)
Discussion started by: edydsuranta
3 Replies
LEARN ABOUT REDHAT
uri::url
URI::URL(3) User Contributed Perl Documentation URI::URL(3)
NAME
URI::URL - Uniform Resource Locators
SYNOPSIS
$u1 = URI::URL->new($str, $base);
$u2 = $u1->abs;
DESCRIPTION
This module is provided for backwards compatibility with modules that depend on the interface provided by the "URI::URL" class that used to
be distributed with the libwww-perl library.
The following differences compared to the "URI" class interface exist:
o The URI::URL module exports the url() function as an alternate constructor interface.
o The constructor takes an optional $base argument. The "URI::URL" class is a subclasses of "URI::WithBase".
o The URI::URL->newlocal class method is the same as URI::file->new_abs
o URI::URL::strict(1)
o $url->print_on method
o $url->crack method
o $url->full_path; same as ($uri->abs_path || "/")
o $url->netloc; same as $uri->authority
o $url->epath, $url->equery; same as $uri->path, $uri->query
o $url->path and $url->query pass unescaped strings.
o $url->path_components; same as $uri->path_segments (if you don't consider path segment parameters).
o $url->params and $url->eparams methods.
o $url->base method. See URI::WithBase.
o $url->abs and $url->rel have an optional $base argument. See URI::WithBase.
o $url->frag; same as $uri->fragment
o $url->keywords; same as $uri->query_keywords;
o $url->localpath with friends map to $uri->file
o $url->address and $url->encoded822addr; same as $uri->to for mailto URI.
o $url->groupart method for news URI.
o $url->article; same as $uri->message
SEE ALSO
URI, URI::WithBase
COPYRIGHT
Copyright 1998-2000 Gisle Aas.
perl v5.8.0 2002-05-09 URI::URL(3)