the input file is
the goal is we will get a new column (include angle information) from the highest correlation between VsperVs column and calculated output.
for this, in my logic is
1. run formula (describe in attached picture) for every angle (from -90 to 90)
2. correlate between formula output from step number one with VpperVs column
3. get the highest similarity
4. output the formula column (include angle information) which has the highest similarity
This issue is very hard for me, please kindly need your help..
the input file is
the goal is we will get a new column (include angle information) from the highest correlation between VsperVs column and calculated output.
for this, in my logic is
1. run formula (describe in attached picture) for every angle (from -90 to 90)
2. correlate between formula output from step number one with VpperVs column
3. get the highest similarity
4. output the formula column (include angle information) which has the highest similarity
This issue is very hard for me, please kindly need your help..
Thanks and regards,
Ipatah
First you solve one or two records of your file by formula you provided using pen and paper and then let us know the expected output.
I don't see too many relations between your input table and the formula you presented. What is A DEPT? What is VPperVS (except it is mentioned that K=VPperVS squared)? Where is Theta defined? Where is Chi defined?
DEPT (should be DEPTH), it just shows where is data taken. VPperVS is taken from measurement, and it will be corelated with our calculated result or EEI (chi).
K is calculated by mean of (Vp/Vs)squared or (Vp/Vs)*(Vp/Vs).
Theta in EEI (θ) should be EEI (χ) or EEI (Chi) I think. χ or Chi are defined by angle (-90 to 90 degree).
So for every DEPTH we have have 180 calculated outputs (from -90 to 90 per 1 degree increment). Note : 180 calculated outputs are EEI(chi) in every angle (from -90 to 90 degree, 1 degree increment)
After we get 180 calculated outputs , these output will be correlated with VpperVs column, In excell file, correlation process need trend correlation, because the calculated output has difference value, example calculated output (in DEPTH 700) has 305.485 and VpperVs has 3.623484.
Thank for your help.. For cross correlation process, could we use Askhay's output and the formula in attached file to get "correl for angle" value. Kindly need your helps..
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)
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)
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)
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)
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)
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... (8 Replies)
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)
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)
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)