📄 0267-0270.html

📁 linux-unix130.linux.and.unix.ebooks130 linux and unix ebookslinuxLearning Linux - Collection of 12 E
💻 HTML
字号:






<HTML>

<HEAD>

<TITLE>Developer.com - Online Reference Library - 0672311623:SAMS TEACH YOURSELF LINUX IN 24 HOURS:Learning Math and Financial Tools</TITLE>

<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
<SCRIPT>
<!--
function displayWindow(url, width, height) {
        var Win = window.open(url,"displayWindow",'width=' + width +
',height=' + height + ',resizable=1,scrollbars=yes');
}
//-->
</SCRIPT>
</HEAD>

 -->




<!-- ISBN=0672311623 //-->

<!-- TITLE=SAMS TEACH YOURSELF LINUX IN 24 HOURS //-->

<!-- AUTHOR=BILL BALL, STEPHEN SMOOGEN //-->

<!-- PUBLISHER=MACMILLAN //-->

<!-- IMPRINT=SAMS //-->

<!-- PUBLICATION DATE=1998 //-->

<!-- CHAPTER=17 //-->

<!-- PAGES=0259-0270 //-->

<!-- UNASSIGNED1 //-->

<!-- UNASSIGNED2 //-->









<P><CENTER>

<a href="0264-0266.html">Previous</A> | <a href="../ewtoc.html">Table of Contents</A> | <a href="../ch18/0271-0274.html">Next</A>

</CENTER></P>



<A NAME="PAGENUM-267"><P>Page 267</P></A>











<P>spreadsheet programs and how they work to a step-by-step guide on how to use teapot.

</P>





<P>Like sc and xspread, the teapot spreadsheet is a space-saving way to handle spreadsheet

data on your computer. You can find a copy of the

teapot spreadsheet at

</P>



<!-- CODE SNIP //-->

<PRE>

ftp://cantor.informatik.rwth-aachen.de/pub/unix/teapot-0.9.tar.gz

</PRE>

<!-- END CODE SNIP //-->





<P>If you'd just like a little information about

teapot, browse to

</P>



<!-- CODE //-->

<PRE>

<a href="http://cantor.informatik.rwth-aachen.de/~michael/projects/teapot-en.html">

http://cantor.informatik.rwth-aachen.de/~michael/projects/teapot-en.html</A>

</PRE>

<!-- END CODE //-->





<H4><A NAME="ch17_ 14">

Finding and Using the Shareware Wingz Spreadsheet

</A></H4>





<P>The Wingz spreadsheet, from Investment Intelligence Systems Corporation, is a

shareware program you can evaluate, use for 45 days, and then pay a registration fee, or

discard. Unlike many shareware programs, this is as capable a spreadsheet program as

many commercial offerings.

</P>





<P>Also, unlike sc, xspread, or teapot, this program requires about six megabytes of hard

drive space when installed. You'll find nearly any feature you could need in a

spreadsheet program, including a built-in scripting language called HyperScript. You can

use HyperScript to build custom interfaces and programs to present your spreadsheet

data. You won't find much documentation, but there are some impressive example sheets

you can load and examine, and Wingz has built-in, context-sensitive help.

</P>





<P>After you install Wingz, you can run the program after first defining the

environment variable, WINGZ. To do this you can define the program at the command line with

</P>



<!-- CODE SNIP //-->

<PRE>

# WINGZ=/pathwhereWingzisinstalled/Wingz ; export WINGZ

# $WINGZ/bin/Wingz

</PRE>

<!-- END CODE SNIP //-->





<P>The first line defines the WINGZ environment variable to point to the

Wingz directory, and the second runs the spreadsheet program. The actual application,

Wingz, is found in the bin directory under the

Wingz directory. You can also run one of two shell scripts included

in the Wingz distribution to temporarily set the

WINGZ variable.

</P>





<P>The Wingz spreadsheet (see Figure 17.4) imports and exports a variety of

well-known spreadsheet file formats, such as Lotus 1.a and 2.0, DIF, text, and SYLK.

</P>





<P>You can generate many different types of 3D graphics, and spreadsheets

may be linked, or previewed before printing. To read more about

Wingz, or to get a copy, browse to

</P>



<!-- CODE SNIP //-->

<PRE>

<a href="http://wingz.iisckc.com">

http://wingz.iisckc.com</A>

</PRE>

<!-- END CODE SNIP //-->





<H4><A NAME="ch17_ 15">

Commercial Features of the Applixware Spreadsheet Program

</A></H4>







<A NAME="PAGENUM-268"><P>Page 268</P></A>











<P>Figure 17.4.<BR>

The Wingz spreadsheet<BR> offers graphics and<BR> desktop

publishing<BR> capability for Linux.<BR>

<a href="javascript:displayWindow('images/ch17fg04.jpg', 288, 216)"><img src="images/tn_ch17fg04.jpg"></a><BR>

</P>





<P>The Applixware spreadsheet program (see Figure 17.5) is part of the

commercial Applixware suite of 10 programs for Linux (see Hour 14, &quot;Text Processing&quot; for

more information). This spreadsheet program is integrated with the other Applixware

programs using linked objects. This means that if you change the data in your spreadsheet file,

the data or chart used in a word processing document will also change.

</P>





<P>As you might expect with a commercial program, this spreadsheet offers all of the

features of competing titles. Besides such features as integration with the other programs in its

suite, print previews, or 3D graphics, this spreadsheet program has drag-and-drop

cell movement, multiple views, and numerous database functions.

</P>





<P>You can import and export many different types of spreadsheet formats, as shown in

Table 17.1.

</P>





<P>Table 17.1. Applixware spreadsheet import and export formats.

</P><BR>



<TABLE>



<TR><TD>

Import

</TD><TD>

Export



</TD></TR><TR><TD>

XLS

</TD><TD>

XLS3, XLS4, XLS5



</TD></TR><TR><TD>

WKS, WK1, WK3, WK4

</TD><TD>

WK1, WK3



</TD></TR><TR><TD>

DIF, XDIF

</TD><TD>

DIF



</TD></TR><TR><TD>

CSV

</TD><TD>

CSV



</TD></TR><TR><TD>

SYLK

</TD><TD>

SYLK



</TD></TR><TR><TD>

text

</TD><TD>

text



</TD></TR></TABLE>





<P>You can find out more about the Applix spreadsheet program by browsing to

</P>







<A NAME="PAGENUM-269"><P>Page 269</P></A>











<P>Figure 17.5.<BR>

The Applixware<BR> spreadsheet has<BR> mouse-driven

toolbars,<BR> style sheets, and<BR> supports multiple<BR> graphics.<BR>

<a href="javascript:displayWindow('images/ch17fg05.jpg', 288, 216)"><img src="images/tn_ch17fg05.jpg"></a><BR>



<!-- CODE SNIP //-->

<PRE>

<a href="http://www.redhat.com">

http://www.redhat.com</A>

</PRE>

<!-- END CODE SNIP //-->





<H3><A NAME="ch17_ 16">

Using gnuplot to Graph Mathematical Formulas

</A></H3>





<P>This section shows you how to use gnuplot, an interactive plotting program by

Thomas Williams and Colin Kelley. This program supports nearly 40 different printers and

output devices, although you'll probably want to experiment with

gnuplot using the X Window System, and print your graphics using PostScript (see Hour 15, &quot;Preparing

Documents,&quot; for more information on how to do this).

</P>





<P>Although gnuplot (no relation to GNU software, but supported and distributed by the

Free Software Foundation under the GNU General Public License) is not the only

mathematical modeling and plotting program available for Linux, it is included on your CD-ROM.

You'll find the gnuplot program under the /usr/bin directory.

</P>





<P>The gnuplot program (see Figure 17.6) is a complete, interactive plotting program, and

was originally designed to graph math functions and data. In this regard it is somewhat

similar to other commercial formula-interpretation and plotting programs. It can read and

save files, and has built-in help, so you can query the program while you use it.

</P>





<P>Using gnuplot is simple. The program has five different command-line options, but

many aspects of the program may be controlled interactively or as commands in a loaded

gnuplot data file. One common use of the command-line option may be to control the point

size (in pixels) of drawing lines using the

-pointsize option, as in the following example:

</P>



<!-- CODE SNIP //-->

<PRE>

# gnuplot -pointsize 2

</PRE>

<!-- END CODE SNIP //-->



<A NAME="PAGENUM-270"><P>Page 270</P></A>











<P>You can use and plot many types of mathematical expressions, and according to the

gnuplot documentation, any C, Pascal, FORTRAN, or BASIC language mathematical

statement may be used. For example, Figure 17.6 shows a graphic plot of the expression (x*y)-(x+y). </P>



<P>Figure 17.6.<BR>

The gnuplot program<BR> can help you visualize<BR> mathematical

formulas<BR> or spreadsheet data.<BR>

<a href="javascript:displayWindow('images/ch17fg06.jpg', 288, 216)"><img src="images/tn_ch17fg06.jpg"></a><BR>

</P>





<P>Once you have finished, type quit to exit the program.

</P>





<P>You can find more documentation, the gnuplot FAQ, and updates to the

gnuplot program at

</P>



<!-- CODE SNIP //-->

<PRE>

<a href="http://www.cs.dartmouth.edu/gnuplot_info.html">

http://www.cs.dartmouth.edu/gnuplot_info.html</A>

</PRE>

<!-- END CODE SNIP //-->





<H3><A NAME="ch17_ 17">

Tips

</A></H3>





<P>Many, many different financial and math applications are available for Linux. This

hour has barely scratched the surface. You'll find financial applications that can help you

manage investment portfolios, track stock prices, or aid in developing cost estimates

for construction projects. You'll also find hundreds of specialized programs you can use

in solving special computing needs for other sciences. One of the best sites for perusing

some of the best of these applications is

</P>



<!-- CODE SNIP //-->

<PRE>

<a href="http://sal.kachinatech.com/">

http://SAL.KachinaTech.COM/</A>

</PRE>

<!-- END CODE SNIP //-->





<P>You'll also find a number of financial tools for Linux, along with source code, at

</P>





<!-- CODE SNIP //-->

<PRE>

<a href="http://sunsite.unc.edu/pub/linux/apps/financial">

http://sunsite.unc.edu/pub/Linux/apps/financial</A>

</PRE>

<!-- END CODE SNIP //-->





<P><CENTER>

<a href="0264-0266.html">Previous</A> | <a href="../ewtoc.html">Table of Contents</A> | <a href="../ch18/0271-0274.html">Next</A>

</CENTER></P>











</td>
</tr>
</table>

<!-- begin footer information -->









</body></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -