Convert Formula to Value

10 More Discussions You Might Find Interesting

1. Solaris

Formula calculate scan rate

Hi There, Just curious here... If there formula to calculate scan rate on solaris? Thanks Edy

2. 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 ...

3. 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,...

4. 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 ...

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

6. 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...

7. UNIX for Dummies Questions & Answers

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...

8. 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...

9. 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...

10. 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...

LEARN ABOUT DEBIAN

spreadsheet::writeexcel::chart::bar

Spreadsheet::WriteExcel::Chart::Bar(3pm)		User Contributed Perl Documentation		  Spreadsheet::WriteExcel::Chart::Bar(3pm)

NAME

       Bar - A writer class for Excel Bar charts.

SYNOPSIS

       To create a simple Excel file with a Bar chart using Spreadsheet::WriteExcel:

	   #!/usr/bin/perl -w

	   use strict;
	   use Spreadsheet::WriteExcel;

	   my $workbook  = Spreadsheet::WriteExcel->new( 'chart.xls' );
	   my $worksheet = $workbook->add_worksheet();

	   my $chart	 = $workbook->add_chart( type => 'bar' );

	   # Configure the chart.
	   $chart->add_series(
	       categories => '=Sheet1!$A$2:$A$7',
	       values	  => '=Sheet1!$B$2:$B$7',
	   );

	   # Add the worksheet data the chart refers to.
	   my $data = [
	       [ 'Category', 2, 3, 4, 5, 6, 7 ],
	       [ 'Value',    1, 4, 5, 2, 1, 5 ],
	   ];

	   $worksheet->write( 'A1', $data );

	   __END__

DESCRIPTION

       This module implements Bar charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:

	   my $chart = $workbook->add_chart( type => 'bar' );

       Once the object is created it can be configured via the following methods that are common to all chart classes:

	   $chart->add_series();
	   $chart->set_x_axis();
	   $chart->set_y_axis();
	   $chart->set_title();

       These methods are explained in detail in Spreadsheet::WriteExcel::Chart. Class specific methods or settings, if any, are explained below.

Bar Chart Methods
       There aren't currently any bar chart specific methods. See the TODO section of Spreadsheet::WriteExcel::Chart.

EXAMPLE

       Here is a complete example that demonstrates most of the available features when creating a chart.

	   #!/usr/bin/perl -w

	   use strict;
	   use Spreadsheet::WriteExcel;

	   my $workbook  = Spreadsheet::WriteExcel->new( 'chart_bar.xls' );
	   my $worksheet = $workbook->add_worksheet();
	   my $bold	 = $workbook->add_format( bold => 1 );

	   # Add the worksheet data that the charts will refer to.
	   my $headings = [ 'Number', 'Sample 1', 'Sample 2' ];
	   my $data = [
	       [ 2, 3, 4, 5, 6, 7 ],
	       [ 1, 4, 5, 2, 1, 5 ],
	       [ 3, 6, 7, 5, 4, 3 ],
	   ];

	   $worksheet->write( 'A1', $headings, $bold );
	   $worksheet->write( 'A2', $data );

	   # Create a new chart object. In this case an embedded chart.
	   my $chart = $workbook->add_chart( type => 'bar', embedded => 1 );

	   # Configure the first series. (Sample 1)
	   $chart->add_series(
	       name	  => 'Sample 1',
	       categories => '=Sheet1!$A$2:$A$7',
	       values	  => '=Sheet1!$B$2:$B$7',
	   );

	   # Configure the second series. (Sample 2)
	   $chart->add_series(
	       name	  => 'Sample 2',
	       categories => '=Sheet1!$A$2:$A$7',
	       values	  => '=Sheet1!$C$2:$C$7',
	   );

	   # Add a chart title and some axis labels.
	   $chart->set_title ( name => 'Results of sample analysis' );
	   $chart->set_x_axis( name => 'Test number' );
	   $chart->set_y_axis( name => 'Sample length (cm)' );

	   # Insert the chart into the worksheet (with an offset).
	   $worksheet->insert_chart( 'D2', $chart, 25, 10 );

	   __END__

AUTHOR

       John McNamara jmcnamara@cpan.org

COPYRIGHT

       Copyright MM-MMX, John McNamara.

       All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.

perl v5.10.1							    2010-02-02				  Spreadsheet::WriteExcel::Chart::Bar(3pm)

Shell Programming and Scripting