<div id="popup_box_thanks" style="display:none" onClick="close_popup_thanks('popup_box_thanks', 'ts')"><br>Thanks for submitting your tip! All submissions are moderated by an editor before appearing online. We've reset the form so you can enter another tip. Or you can close the tip submission box. <div class="x_close" id="thanks_upper_right"><a href="javascript:void(0)" onmousedown="close_popup_thanks('popup_box_thanks', 'ts'); return true;">Close</a></div></div>
<div class="tbf_row"><div class="tbf_wide_extra_top not_bold">Please submit only technical tips that will help other TidBITS readers better use their Macs, iPhones, and related software and hardware. All product announcements should be sent to <a href="mailto:releases@tidbits.com">releases@tidbits.com</a>.</div></div>
<div class="tbf_left">URL</div><div class="tbf_right"><input type="text" value="" name="tip_link_url" tabindex="3"><span class="tip_description"><br>Enter the URL to a Web page that supports your tip.</span></div>
</div>
<div class="spacer"></div>
<div class="tbf_row">
<div class="tbf_left">Linked text</div><div class="tbf_right"><input type="text" value="" name="tip_link_label" tabindex="4"><span class="tip_description"><br>Enter the name of the page linked above.</span></div>
<div class="tbf_wide"><input type="submit" value="Preview Your Tip" name="preview_tip" onClick="fill_preview('tipbits_enclosure_preview', 'ts', this.form); return false;" tabindex="7"> <input type="submit" value="Send Us Your Tip!" name="submit_this_tip" onClick="handle_tip_submission('ts', '', this.form, 'tip'); return false;" tabindex="8"></div>
</div>
<div class="spacer"></div>
<div class="tbf_row">
<div class="tbf_wide"><span class="fine_print">When you submit a tip, you give us permission to use it. Read <a href="javascript:void(0)" onClick="generic_show_hide('tip_terms')">our terms</a> for more details. All submissions are reviewed before publication.</span></div>
<div class="tbf_wide"><span class="fine_print">Our terms: By submitting a tip, you agree to assign TidBITS Publishing Inc., a non-exclusive, worldwide, perpetual license to reproduce, publish, and distribute your tip in connection with the TidBITS Web site and associated products in any media. You agree that you created the content you submitted, and that you have the right to assign us this license. You give us permission to use your name, but your email address won't be publicly displayed or shared. We review all submissions before publication, and reserve the right to select which submissions we feel are appropriate for our readers and to edit those we publish.</span></div>
<div id="comment_thanks" style="display:none" onClick="close_popup_thanks('comment_thanks', 'comm')"><br>Thanks for submitting a comment! Please check your email for a link that, when clicked, will verify that you're a real person and cause your comment to appear immediately. <div class="x_close" id="comment_upper_right"><a href="javascript:void(0)" onmousedown="close_popup_thanks('comment_thanks', 'comm'); return true;">Close</a></div></div>
<div class="tbf_wide"><span class="fine_print">Our terms: We reserve the right to edit or delete any comment, so please post thoughtfully. We use your email address <i>only</i> to send you a one-time verification message confirming that you posted this comment. We also store your address to allow you to verify using other Web browsers in the future. For more info, see our <a href="http://db.tidbits.com/privacy.html">privacy policy</a>.</span></div>
<li><a href="/feeds/tidbits.rss" title="Subscribe via RSS" class="gettb">RSS <img src="/images/feed-icon-12x12.gif" width="12" height="12" border="0" class="nav_img" alt="Subscribe via RSS"></a></li>
<li><a href="http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=276986548" title="Subscribe to the podcast" class="gettb">Podcast <img src="/images/feed-icon-12x12_podcast.gif" width="12" height="12" border="0" class="nav_img" alt="Subscribe to the postcast"></a></li>
<li><a href="http://www.twitter.com/TidBITS" title="Get Article Updates via Twitter" class="gettb">Twitter <img src="/images/feed_icon_12x12_twitter.png" width="12" height="12" border="0" class="nav_img" alt="Get Article Updates via Twitter"></a></li>
<li><a href="http://www.facebook.com/pages/TidBITS/195314925519" title="Go to the TidBITS Page at Facebook" class="gettb">Facebook <img src="/images/feed_icon_12x12_facebook.gif" width="12" height="12" border="0" class="nav_img" alt="Go to the TidBITS Page at Facebook"></a></li>
<li><a href="javascript:void(0)" title="Sections" class="tabhead" onClick="return showhide('articleslist')">Sections <span id="articleslist_triangle"><img src="/images/nav_triangle_open.gif" width="9" height="9" border="0" class="navtriangle" id="articleslist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" onClick="return showhide('stafflist')" title="Staff" class="tabhead">Staff <span id="stafflist_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="stafflist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" title="Issues" class="tabhead" onClick="return showhide('issuelist')">Weekly Issues <span id="issuelist_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="issuelist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" onClick="return showhide('abouttidbits')" title="About TidBITS" class="tabhead">About TidBITS <span id="abouttidbits_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="abouttidbits_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<div class="center_top">Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling <a href="http://www.takecontrolbooks.com/?pt=TB-TAGLINE" style="color:yellow">Take Control</a> ebooks.</div>
<!-- begin centercolumn -->
<div id="centercolumn">
<!-- begin rightcolumn_container -->
<div id="rightcolumn_container">
<!-- begin rightcolumn -->
<!-- rightcolumn is embedded within centercolumn so featured text wraps around it -->
</div><!-- end tearoffbox_wide_container for watchlist items -->
<!-- begin tearoff box wide -->
<div class="tearoffbox_wide_container">
<div class="tearoffbox_wide_tips">
<div class="tip_display">
<div class="tips_sponsor_logo">
</div>
<h6>Move the Dock Quickly</h6>
<p><p>You may find it convenient to move the position of the Dock when working in certain programs or with certain files. Rather than choosing a different position from the Dock preferences pane or using a submenu in the Apple menu's Dock submenu, you can move your Dock to a different screen edge merely by Shift-dragging the separator that divides the application and document sections.</p></p>
<div class="tbf_wide_80" id="hc_rc_2910">To help us avoid automated posts and misuse of our site, please enter the words below.</div><div class="x_close_row" id="hc_upper_right2_2910"><a href="javascript:void(0)" onmousedown="HidePopupContent('hc_2910', 'hc', '2910'); return true;">Close</a></div>
<div class="featured_meta"><div class="meta_article">26 May 1997 | <a href="/article/2180?print_version=1">Print <span class="shift_up"><img src="/images/printer_icon.gif" alt="Printer-Friendly Version of This Article" border="0" width="9" height="10"></span></a></div></div>
<div id="article_box_2910"><P>At a time when Apple and the Macintosh seem to be whirling in fragments around my head, the release of Spreadsheet 2000 from Casady & Greene has given my spirits a much needed lift. It is a powerful, flexible, interesting way to store and retrieve information (in this case, numerical information, along with calculations). That, as longtime TidBITS readers know, goes right to the heart of what I want from my Mac. The light-hearted interface shows that there is still room for originality on the Mac. It is easy to learn: you do the tutorials, you grok the metaphor, and from then on it's completely intuitive. It was basically written by Steve Wilson of Emergent Behavior, reaffirming the place of small developers. And, the fact that Spreadsheet 2000 was written with Prograph CPX, my favorite Mac development environment (see <A HREF="http://www.tidbits.com/tb-issues/TidBITS-312.html">TidBITS-312</A>), is a delightful bonus.</P><P><<A HREF="http://www.casadyg.com/C%26G/Welcome.html">http://www.casadyg.com/C&G/Welcome.html</A>></P><P>Spreadsheet 2000, officially abbreviated S2K, is actually version 2.0 of Let's Keep It Simple Spreadsheet, officially abbreviated Let's KISS, or LKISS, or just plain KISS.</P><P><STRONG>Go With the Dataflow</STRONG> -- A spreadsheet is a place where, typically, numbers live, some of which are the result of live calculations using others. For instance, in recording a budget, altering or adding a figure in a column of food-related expenditures for the month might automatically change entries for the month's food total, the month's grand total, and the year-to-date grand total.</P><P>In most spreadsheet programs, this is done through hidden formulas. You are presented with a blank grid of cells, into each of which you can put either a number or a formula describing a calculation based on other cells. A cell containing a formula, though, shows only the result of the formula's calculation. That number can then be used in still other formulas, and so on. This means that you must learn a formula language, which is often difficult. More important, it means that a spreadsheet is hard to explore and easy to harm: since you cannot usually see the formulas (and even when you can, it is hard to trace a cell's formulaic dependencies), you may accidentally make a change that causes a formula to give a bad result, or one that overwrites a formula altogether.</P><P>Spreadsheet 2000 is nothing like this. Instead, you are presented with a completely empty window. Into this window you place, by drag & drop from palettes, any of a number of objects, and by dragging arrange them as you like, much as in a drawing program. These objects are principally either rectangular grids of cells, or operators (such as "+", "*", "avg", and so on) represented as small named rectangular panels. You then click to draw connecting lines leading from grids to operators, and from operators to other grids ("output" grids). You can put numbers into the cells of grids - but not if they are output grids (output grids automatically take on a different color). So, the results of calculations are specially marked and automatically protected. Also, the structure of each calculation is visible as a physical flow of data: from an input grid or grids, through an operator, to an output grid.</P><P>The chain of grid-operator-grid can be extended as long you like; a grid may serve as input to more than one operator, and an operator may require input from more than one grid. To prevent a clutter of such chains from tangling up like spaghetti, you can select a segment of chain and "crunch" it, replacing it by a single custom operator. If you double-click the custom operator, an edit window opens and displays the grids and operators you crunched. You can work in this edit window, rearranging elements, altering data, modifying calculations, and even crunching segments of chain within it, too. By judicious naming and arrangement of crunched custom operators, you can create visual calculation structures which remain neat and easy to understand; yet the details remain available by quickly drilling down, opening the edit windows of custom operators to any desired level.</P><P>Spreadsheet 2000 also provides a second way to avoid clutter. This is called a report, though I prefer to think of it as a view, since it's really another way of looking at particular portions of your data. The main window (called the Master) is replaced by one containing just a designated subset of elements: typically, one window might show two or three chief grids, with no operators or connections at all. A document can have many different named reports, listed in a Report menu, and at any given moment you see either one report or the Master (which is another reason I call them views). How you use reports is up to you. You can enter data in a report, so when a calculation involves a lot of bits of data, multiple reports can provide multiple entry forms. They are also good places to summarize the grand results of a calculation.</P><P>I mentioned earlier that spreadsheet elements are added by drag & drop from palettes. You may create your own palettes to store elements you might need later (libraries, in other words). Such elements might range from a complicated, crunched custom calculation that generates histogram information to a simple, frequently needed grid of data or an empty 12-row grid labelled with the names of the months.</P><P>Spreadsheets can also contain special elements, such as charts that automatically show simple but effective graphs of any grid connected to them. There are also notes - simple text rectangles useful for placing comments and instructions - and graphics. These can all be arranged as desired, of course.</P><P><STRONG>True Grid</STRONG> -- All data entry and display is, as already stated, by way of grids. You can type data directly into a grid cell, and of course you can cut and paste data between grids and another applications (S2K does some intelligent processing of clipboard contents); you can also export grid data as tab-delimited text files.</P><P>A grid can be resized to any rectangular dimensions in terms of the cells it contains: it can be a single cell, a single column, a single row, or a full rectangle. Labels can be attached to any grid's top, side, or both, letting you specify what each column or row denotes; with output grids you can attach labels yourself, or tell an operator to allow its input's labels to "flow through," so that the operator's output grid reproduces them.</P><P>The display of numeric data can be formatted by dragging & dropping a formatting icon onto it; various basic formatting icons live in a toolbar at the top of the screen, or you can tear off a formatting palette which lets you be more specific about things like the number of decimal places to be displayed. Text formatting works similarly, or you can choose from a Text menu. S2K enforces formatting consistency: you can numerically format a whole grid or selected columns, or textually format a whole grid or all top or side labels, but not individual cells.</P><P>One of Spreadsheet 2000's cleverest features is the intelligent behavior of its operators with respect to grids. Take, for example, the "+" operator: what it does depends on the shape you give its output grid. Imagine you have a 5-by-4 grid of numbers connected into a "+" operator. If the "+" operator is then connected to a single-cell grid, that cell will display the sum of all 20 input cells. If it is connected to a single-row grid, that grid is automatically resized to 5-by-1, and displays the sum of each column of the input. If it is connected to a single-column grid, that grid is automatically resized to 1-by-4, and displays the sum of each row of the input.</P><P>Other operators that take multiple inputs react to the shapes of those inputs. For instance, the "A+B" operator, which adds two inputs, will add two single-column grids by making the output a single column each of whose cells contains the sum of the corresponding pair of cells. It will add a rectangle grid to a single-column grid by making a rectangle grid, summing corresponding pairs of cells one column at a time. It will add a single-column grid to a single-row grid by making a rectangle grid, each cell containing one of the possible sums of pairs. And so on.</P><P>The extraordinary thing is that, although this sounds very involved when I describe it, in action it is immediately obvious and intuitive. S2K gives you a sense of doing the right thing, of knowing what you mean (often better than you do yourself!).</P><P><STRONG>Spreadsheet Icing</STRONG> -- Native operators include standard numeric functions (arithmetic, trigonometric, exponential, rounding), and "form" operators act as a shortcut in the composition of elementary algebraic expressions; basic statistical functions (such as average and standard deviation) are included too. Grid operators let you count cells, columns, and rows; combine or decompose grids; copy, rotate, and sort grids; and extract grid parts by various match criteria. Logical operators let you perform Boolean tests and even build "if-then-else" constructs. Loop operators generate automatic fill data, and let you construct cumulatively computed output grids (such as a running bank balance).</P><P>These operators turn out to be sufficient for most needs; the trick, when you want to build a new function, is getting used to the dataflow model, which works differently from an algebraic language. To help you, a large selection of pre-built custom operators is included; these can be used as shortcuts, and (being constructed from the native operators) they are also valuable study models. They range from simple unit conversions and physical constants to arithmetic representations of complex numbers, polynomial roots, primeness test, Fibonacci series, pseudo-random number generation, linear regression, and various financial operators - enough to prove that S2K's dataflow language is pretty powerful (especially considering its lack of recursion).</P><P>Many model solutions are also included in the form of stationery and other files. Again, the wide range testifies to Spreadsheet 2000's power: break-even and depreciation, budget and car leasing, triangle solution, Fourier sine wave addition, numeric integration by Simpson's rule, a gradebook, even baseball statistics. More user-created templates can be found on Casady & Greene's Web site.</P><P><<A HREF="http://www.casadyg.com/C%26G/Products/spreadsheet_2000/Solutions/solutions.html">http://www.casadyg.com/C&G/Products/ spreadsheet_2000/Solutions/ solutions.html</A>></P><P>The manual, unfortunately, fails to document any of this (except for the native operators). Otherwise, though, it is quite nice: it consists mostly of chatty tutorials and general advice, followed by some lightly written reference material, which is all you need because the program is easy to use once you've done the tutorials. There is also good balloon help, plus some Apple Guides.</P><P><STRONG>The Magic Draggin'</STRONG> -- If I have one overall complaint about Spreadsheet 2000, it is that the program is strongly mouse-oriented. I like dragging & dropping as much as the next person (and S2K's optional sound effects add to the fun), but the program calls for more physical dexterity than I possess and more reaching hither and yon than I have patience for.</P><P>I've made this and several other suggestions to S2K author Steve Wilson - such things as having crunched operators' edit windows remember their size and position next time they're opened, and an optional dialog to make it easier to size a grid. His receptive attitude suggests that, with constructive suggestions from users, S2K's future incarnations will be even better.</P><P>Having exhausted my feeble supply of negatives, I'll reiterate: Spreadsheet 2000 is a fine program. It seems rock solid (I haven't been able to make it choke or crash); its behavior is intuitive and convenient. It has those direct, simple, Mac-defining qualities that come along once in a blue moon, giving it the potential to be a classic. It performs a powerful, basic function, yet is easy to learn, and satisfying and fun to use. In my opinion it is the everyday spreadsheet that every Mac owner must have.</P><P><STRONG>Hot Off the Grid</STRONG> -- A splendid QuickTime movie showing S2K in action can be found on Casady & Greene's Web site (200K), along with demo versions of S2K for both 68K and PowerPC-based Macs (a little over 2 MB):</P><P><<A HREF="http://www.casadyg.com/C%26G/Products/spreadsheet_2000/S2Kmov.html">http://www.casadyg.com/C&G/Products/ spreadsheet_2000/S2Kmov.html</A>></P><P>In our checking, the street price for Spreadsheet 2000 ranged from $60 to $75, and there's currently a $30 rebate if you own another spreadsheet. The LKISS upgrade is $20 (free if purchased in 1997).</P><P><<A HREF="http://www.casadyg.com/C%26G/Products/spreadsheet_2000/description.html">http://www.casadyg.com/C&G/Products/ spreadsheet_2000/description.html</A>></P><P><STRONG>DealBITS</STRONG> -- Through the URL below, Cyberian Outpost is offering TidBITS readers Spreadsheet 2000 for $54.95, which is $5 off the standard price.</P><P><<A HREF="http://www.tidbits.com/products/spreadsheet-2000.html">http://www.tidbits.com/products/spreadsheet- 2000.html</A>></P><!-- A Spreadsheet for the Millennium Matt Neuburg --></div>
<!-- end article text -->
<!-- PayBITS -->
<p> </p><div class="sponsorbox">
<div class="sponsortext"><A HREF="http://www.usefulfruit.com/tb"><IMG SRC="http://db.tidbits.com/images/badges/pear-note-icon50x50.png" ALT="" HEIGHT="50" WIDTH="50" BORDER="0" ALIGN="left"></A>Pear Note 2: More complete, understandable notes on your Mac.<br />Typed notes are blended with recorded audio, video, and slides<br />to create notes that make more sense when you need them most.<br />Learn more at <<a href="http://www.usefulfruit.com/tb">http://www.usefulfruit.com/tb</a>>!</div>
