http://creativecommons.org/licenses/by-sa/2.5/ <p>My contribution to the OOo community &#8211; including a blog with daily tips, templates and scripts for downloading, as well as links to other related websites. Enjoy.</p> OpenOffice Tips Fri, 03 Jun 2005 00:35:50 -0700 Fri, 26 Aug 2005 08:21:12 -0700 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Basic+Functions%3A+COUNTBLANK/bzaz The COUNTBLANK function allows you to total the number of blank or empty cells in a specified range. It is used as show n below in the example. Cells C3, B5 and D5 are empty - so the COUNTBLANK function... 画像 写真 アイドル グラビア 水着 沼尻沙弥香 Thu, 02 Feb 2006 10:31:22 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Conditional+Formatting%3A+Comparing+two+Lists/byt4 We will use conditional formatting to identify unique entries between two lists. In the sheet below, we have two lists of US States. We would like to identify the list entries that are unique to each list. This technique can... bonsai care, Gardening, Bonsai, hydroponics containers, Wed, 01 Feb 2006 05:41:52 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Entering+Dates+Quickly/byqg Here is a useful formula - a long with a variant if you need to enter dates quickly without the delimiters between the days, months and years. In the example below, we enter our shorthand dates in column B. This... estate real Tue, 31 Jan 2006 22:17:51 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Returning+a+Blank+rather+than+Zero+or+Error/bx7n In the spreadsheet below, we wish to apply a formula to the values of a particular column - C and display the results in column D. However, the column is 'sparse' in that not all cells in the column have... Mon, 30 Jan 2006 13:09:18 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Toolbar+Crazy/bx7m I'm not a big user of the OpenOffice Calc toolbars - but I was curious what it would look like if I activated them all... You can enable/disable a particular toolbar with the View - Toolbars menu option. As you... Mon, 30 Jan 2006 13:09:18 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Creating+a+2-D+Lookup+Table/bx7l By combining INDEX and MATCH functions as shown below, we can create a lookup table whose data can be accessed by specifying the desired row and column values. This is probably best applied where the lookup table is of fixed... Mon, 30 Jan 2006 13:09:18 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/A+Sudoku+Solver%21/broq I have been wanting to do this for the longest time - ever since I became aware of this puzzle last year. So for the past week, I've been busy putting together this spreadsheet that will assist you with solving... Fri, 06 Jan 2006 19:58:31 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Data+Validation%3A+Drop+down+lists/bqnw For each cell, you can define in advance what type of contents is valid for that cell. This allows you to guide users through data entry in OpenOffice.org Calc by restricting cells to receive specific values and ranges. For selected... Fri, 06 Jan 2006 16:28:43 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Basic+Functions%3A+WEEKDAY/bpr2 The WEEKDAY function returns an integer that represents the day of the week. The usefulness of this function is in identifying weekends in a series of dates. It is straightforward to use the filldown functionality of Openoffice Calc to create... Fri, 30 Dec 2005 08:49:47 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Basic+Functions%3A+WEEKDAY/bpnm The WEEKDAY function returns an integer that represents the day of the week. The usefulness of this function is in identifying weekends in a series of dates. It is straightforward to use the filldown functionality of Openoffice Calc to create... Thu, 29 Dec 2005 23:39:01 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Splitting+an+address+%28US%29+into+separate+cells/bo70 The FIND, LEFT, MID, RIGHT and LEN text functions are extremely useful and versatile. We have seen before how to split a person's name into it's component parts. Here, we take a single cell containing a US address and split... Wed, 28 Dec 2005 20:08:56 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Financial+Functions%3A+Creating+a+Payment+Chart/bosq One of the most useful and widely used financial functions available in OpenOffice Calc is PMT. We have discussed this before. It's use is illustrated below in a simple example showing how to calculate the payments on a loan with... Tue, 27 Dec 2005 12:21:51 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Merry+Christmas/bnz0 Here's wishing you all a Merry Christmas and a prosperous 2006! I have not been updating recently - but I plan to get back into the swing of things as soon as I can after the holidays. Right now, I... Sat, 24 Dec 2005 13:25:25 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Financial+Functions+%3A+Balloon+Loan+Example/bfuk A balloon mortgage is a short loan, lasting five to seven years, but the payments are based on a term of 30 years. Balloon loans often have a lower interest rate, and can usually be easier to qualify for than... Sat, 03 Dec 2005 17:38:07 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Converting+time+to+minutes+past+midnight/bel8 To convert a time to the number of minutes past midnight, just multiply by 1440 - as shown below. You also need to make sure the result cell is formatted as a number.... Wed, 30 Nov 2005 22:34:41 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Sheet%2FCell+Protection+101/bbjb There are a number of situations where it is desirable to take advantage of the sheet/cell protectection features of OOo Calc. Perhaps you want to prevent the values for a range of cells from being overwritten. Perhaps, you want to... Wed, 23 Nov 2005 01:18:39 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Regular+Expressions+101/baxg This is a topic that you will best learn by trying out stuff for yourself - but here I summarize the basics... There are a number of builtin functions that make use of regular expressions. Here, we use COUNTIF to... Mon, 21 Nov 2005 20:01:58 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Google+Analytics/bawp From the company that seems to do everything right... Google Analytics allows you to take a closer look at the folks that visit your website. One of the coolest features is the ability to create a distribution map - below... Mon, 21 Nov 2005 19:01:57 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Charting%3A+Modifying+the+axis+scaling/8c0 By default, OOo Calc will create a chart with the y-axis starting at 0 (zero). For most purposes, this is adequate, but it is quite straightforward to shift the axis up (or down) where desired. For the Flash version of... Tue, 15 Nov 2005 23:00:03 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Naming+Multiple+Cell+Ranges/7wg Consider the simple example below - a table with various columns of data. Any formulas we create would be much more readable if we assigned names to the columns of the table. With the full table selected, choose Insert -... Mon, 14 Nov 2005 23:40:46 -0800 http://swik.net/OpenOffice/OpenOffice+Calc+Tips/Basic+Functions%3A+SUBSTITUTE/6oj The SUBTITUTE function replaces a sequence of characters with a different sequence of characters in a text string. The arguments to the functions are : SUBSTITUTE(text, old_text, new_text [,instance_num]) where text The text for which you want to substitute characters.... Fri, 11 Nov 2005 23:23:53 -0800