Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Formula help
Top Forums UNIX for Dummies Questions & Answers Formula help Post 302179409 by era on Thursday 27th of March 2008 03:58:57 PM
Old 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

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

LEARN ABOUT DEBIAN

excel::template::element::formula

Excel::Template::Element::Formula(3pm)			User Contributed Perl Documentation		    Excel::Template::Element::Formula(3pm)

NAME

       Excel::Template::Element::Formula - Excel::Template::Element::Formula

PURPOSE

       To write formulas to the worksheet

NODE NAME

       FORMULA

INHERITANCE

       Excel::Template::Element::Cell

ATTRIBUTES

       All attributes a CELL can have, a FORMULA can have, including the ability to be referenced using the 'ref' attribute.

CHILDREN

       None

EFFECTS

       This will consume one column on the current row.

DEPENDENCIES

       None

USAGE

	 <formula text="=(1 + 2)"/>
	 <formula>=SUM(A1:A5)</formula>

	 <formula text="$Param2"/>
	 <formula>=(A1 + <var name="Param">)</formula>

       In the above example, four formulas are written out. The first two have the formula hard-coded. The second two have variables. The third
       and fourth items have another thing that should be noted. If you have a formula where you want a variable in the middle, you have to use
       the latter form. Variables within parameters are the entire parameter's value.

AUTHOR

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       CELL

perl v5.14.2							    2010-06-17				    Excel::Template::Element::Formula(3pm)
All times are GMT -4. The time now is 01:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy