INTAC - Internet Access Linux Gifts and for Microsoft Windows Users MozillaQuest MQ Logo
MozillaQuest the on-line computer magazine
December 21, 2003

TotalShells.com

EPIX Internet Services
MozillaQuest Magazine Front Page button

Internet & Web browsers button

custom Netscape & Mozilla themes & skins button

Digital Photography

Graphics

IRC - Internet Relay Chat - Chat button

Linux buttonLinux for Windows Users

Mozilla button

Multimedia

Netscape button
network articles

tutorial - help - how to button

Web Page Design

Web Tools

Windows button


Creating a Personal or Company Budget with OpenOffice/StarOffice Calc

Part 1: Basics

Mike Angelo -- 21 December 2003 (C) -- Page 2

  • Labeling the columns or data fields

Next place the mouse pointer at the top-left of the spreadsheet and click to open the first cell of the document for input. This should be cell A1. Please see Figure 2, below.

Please take a look at the bottom toolbar, the Formula Bar. Notice the letter-number combination in the input-selection box on the Formula Bar. It's right under the Font input-selection box on the Object Bar in Figure 2, below.

That letter-number combination is the currently selected cell or cell range. You can select a cell or range of cells by typing it into that cell input-selection box.

If you are new to spreadsheets, cell names such as A1 or B5 are made by taking the letter at the top of the spreadsheet designating the column such as A, B, C, and so forth and adding that to the row number at the left edge of the spreadsheet designating the row such as 1, 2, 3, and so forth. Thus cell D6 is the cell in column D and row 6. In Figure 2, cell D6 is the Mortgage Payment cell.

Now, if you already have not done so, please type "OpenOffice Monthly Budget Demo" or whatever you would like to call your budget into Cell A1. Then click on the center, text-alignment icon on the Object Bar. Next highlight the budget title and click the down arrow on the Font Size box on the Object Bar. It's just to the right of the Font Selection box. Or, you can go to the Font Tab under the Format Menu as we did above. Then select 20-pt. type. Please see Figure 2, below.

To finish your budget title for now, simply click the B button on the Object Bar or on Bold in the Typeface selection box in the Format Menu > Cell > Font Tab. You now should have the title of your budget centered at the top leftmost cell set in 20-pt., bold, Nimbus Sans L type.

Please notice that the entire OpenOffice Monthly Budget Demo title is only in the top-left cell, A1. Moreover, it appears to flow into the next six cells, A1 through F1. Please see Figure 2, below.

However, it really does not. That's just a spreadsheet display illusion. Further on in this tutorial, we will merge the OpenOffice Monthly Budget Demo title into cells A1 through H1 so that it truly will be centered across the top of your budget. Please see Figure 3 on page 3.

Figure 2. Starting working-view of the OpenOffice Monthly Budget Demo opened in a Calc. Please see text for an explanation and Figure 3 for the finished working view.

You periodically should save your work in case your program or computer crashes or in case you make a mistake that you cannot back out of easily. That way you do not lose everything. This would be a good place to save what you already have accomplished.

You have a choice of file formats in which you can save your budget spreadsheet. Instead of using the default OpenOffice-Calc file format, sxc, let's use the MS-Excel file format, xls. The reason for using the MS-Excel file format is so that associates with whom you might share files and who use MS-Excel can read and work with your budget spreadsheet.

To do that, please click on File > Save As and then on the Save as type down arrow. Then please scroll to Microsoft Excel 97/2000/XP (xls;xlw) and click it. Next please insert OpenOffice-Calc-Demo-Contact-Manager.xls into the File name input box and click Save.

When you execute a save command in the .xls format, Calc might prompt you to save in the Calc format instead. Just say NO and save it in the .xls format.

Now, let's add the heading for each column in your budget. To do that, please start by typing Income in cell A4.

Then hit the TAB key thrice to advance the insertion point to cell D4. Next, type Fixed Expenses into cell D4.

In similar fashion, let's add Regular Expense Estimates into cell G4.

Rows 2 and 3 plus Columns B, C, E, and F intentionally have been left blank for now.

Next, please insert Day Job, Moonlight Job, and CD Interest into Cells A6, A7, and A8 respectively. These are your sources of income for this demonstration budget. You can use the keyboard down-arrow to move down to the next cell.

For your demonstration budget Fixed Expenses let's add Mortgage Payment, Car Payment, and Internet Connection into Cells D6, D7, and D8 respectively.

Now let's add the Regular Expense Estimates, Food, Gas, Electric, and Phone into Cells G6, G7, G8, and G9 respectively.

To finish all the labels for now, let's do the totals. Total Income goes into Cell A12, Total Fixed Expenses in D12, and Total Estimates in G12.

Then label Cell A14 Total Expenses and Cell A16 Disposable Income.

At this point, your budget spreadsheet should look similar to the one in Figure 2.

Please feel free to add any other columns or items you like for your budget spreadsheet. The items included in the demo budget are far from a complete or exhaustive list of budget items.

  • Formatting the cells

If you are not familiar with formatting Calc spreadsheet cells, please see the Formatting the cells section in our Calc Contact Manager article. Once you have done that or if you already know how to format cells, here are the cell formats for your budget spreadsheet. All these settings can be found in the Format > Cells tabs.

Income, Fixed Expenses, and Regular Expense Estimates get set to Text, Nimbus Sans L, 16-pt, Bold, Underlined, Horizontal Center, Vertical Middle, and NO Automatic line break -- except for Regular Expense Estimates, which gets set to Automatic line break.

As you implement the cell formatting, some text will start to word-wrap or seem to move across cell boundaries. Don't worry about that now. It all will come into alignment when we adjust the column widths further on.

The actual data items Day Job, Moonlight Job, CD Interest, Mortgage Payment, Car Payment, Internet Connection, Food, Gas, Electric, and Phone should be set to Text, Nimbus Sans L, 12-pt, Regular, Horizontal Left, Vertical Middle, and NO Automatic line break.

Next, please set Total Income, Total Fixed Expenses, Total Estimates, Total Expenses, and Disposable Income to Text, Nimbus Sans L, 12-pt, Bold, Horizontal Left, Vertical Middle, and NO Automatic line break.

Columns B, E, and H from Row 6 down will contain dollar amounts. So, please set Columns B, E, and H from Row 6 down to Currency, Nimbus Sans L, 12-pt, Regular, Horizontal Right, Vertical Middle, and NO Automatic line break. Use the -$1,234.00 Currency format with 2 Decimal places and 1 Leading zeros. Negative numbers red and Thousands separator should be checked.

Next, please set a 1.00 pt single-line bottom border for Cells B11, E11, and H11.

In order to set the column widths, please insert 1600 into cell B6, 400 into cell E6, and 400 into cell H6. The currency formatting that you did above for these cells should cause these numbers automatically to jump to $1,600, $400, and $400.

Use the automatic column-width feature to set the column widths for columns B, D, E, and H. Drag the Column A-B boundary to the position at which Disposable Income is on one line. Then drag the Column G-H boundary to the position at which Regular Expense is on one line with Estimates below it.

Perhaps you have been wondering why columns C and F have been left blank. They are used for spacers. Please now set them to widths of 0.13 inches to set the spacing. (We used 0.13-inches in order to get the sheet to fit in the column width in this article. However, to make your sheet look nicer, use a wider width for columns C and F.)

By now, your budget spreadsheet should look much more like the one in Figure 3 than the one in Figure 2. This would be a good place to save your work so far.

Article Index

Related Articles


OpenOffice 1.1 -- A Complete Office/Productivity Software Suite for GNU-Linux, FreeBSD, MAC, MS-Windows, Unix, and more

Creating a Simple Newsletter with OpenOffice/StarOffice Writer - a free word processor for GNU-Linux, FreeBSD, MAC, MS-Windows, Unix, and more

Creating a Simple Contact or Personal Information Manager with OpenOffice/StarOffice Calc - a free spreadsheet for GNU-Linux, FreeBSD, MAC, MS-Windows, Unix, and more


SUSE Linux Has New Educational Discount Program - 9.0 Professional Only $50 for Students, Teachers, Schools

Crossover Office 2.1 Runs MS Windows Software on GNU-Linux Systems -- Jeremy White, and Mike Angelo Discuss Crossover Office, Wine, and MS Windows APIs for Linux

MandrakeSoft's 8 Golden Rules


Young People Are The Future of Linux -- Gaël Duval, Joe Eckert, Randy Plessor, Jeremy White, and Mike Angelo Discuss Linux and Open-Source Software in Schools and Colleges

SuSE Linux Desktop Available

A KDE Tool to Manage and Read E-Mail: KShowmail Shows Potential -- But It Can Delete the Wrong Messages


Using LinNeighborhood to Create a Network Neighborhood for Linux

Linux Networking for Windows and Desktop People -- Mandrake 9.1 and LinNeighborhood


Mozilla 1.3b Browser-Suite Released


Copyright 2000-2003 -- MozillaQuest -- Brodheadsville, Pa..USA -- All Rights Reserved
Recent Articles

MandrakeSoft's 8 Golden Rules

A KDE Tool to Manage and Read Email: KShowmail Shows Potential - But Can Delete the Wrong Messages

OpenOffice 1.1 -- A Complete Office/Productivity Software Suite for GNU-Linux, FreeBSD, MAC, MS-Windows, Unix, and more

SUSE Linux Has New Educational Discount Program - 9.0 Professional Only $50 for Students, Teachers, Schools

Crossover Office 2.1 Runs MS Windows Software on GNU-Linux Systems -- Jeremy White, and Mike Angelo Discuss Crossover Office, Wine, and MS Windows APIs for Linux

Mandrake Linux 9.2 Available

Young People Are The Future of Linux - Linux and Open-Source Software in Schools and Colleges

CNN SUCKS!

Gaël Duval Tells Why Mandrake Linux Is Better Than MS Windows

Gaël Duval and Mike Angelo Discuss The HP-Mandrake Computer

HP to Ship Desktops with Mandrake 9.1 Linux Pre-Installed - Good News for Mandrake Linux and Fans

Mozilla 1.4 Browser-Suite -- AKA Netscape 7.1

Gaël Duval and Mike Angelo Discuss Mandrake Business Products and Finances

SuSE Linux Desktop Available

About the Hey SCO, sue me Petition

Linux for Windows Users -- Linux Networking for Windows and Desktop People -- Mandrake 9.1 and LinNeighborhood

Gaël Duval and Mike Angelo Discuss the New AMD64 OS --

Mandrake Linux Corporate Server 2.1 for AMD Opteron

SuSE Linux Enterprise Server 8 for AMD64 Released

Major Morphing in Mozilla Project Organization and Objectives Proposed

Red Hat Linux 9 Distribution Released

SCO-Caldera v IBM:

  • Are SCO's Rebuilt IBM Lawsuit and Unix License Revocation Winners -- Or More SCO FUD?

Mandrake Linux Corporate Server 2.1 Released

SCO-Caldera & the GNU/Linux Community: The SCOsource IP Matter

Mozilla 1.0 updated!

Don't Forget the Books

Linux Makes a Great Gift

Christmas Season Holidays & Computer Suggestions 2002

Mozilla 1.2.1 Browser-Suite Released

Buggy Mozilla 1.2 Recalled

Mandrake Linux 9.0, Desktop Magic You Can Use: A First Look

Using LinNeighborhood to Create a Network Neighborhood for Linux

Zero Tolerance for Privacy and Security Bugs

Mozilla and Netscape JavaScript Bugs Compromise Privacy and Security

SCO's Darl McBride and MozillaQuest Magazine's Mike Angelo Discuss Caldera Linux and LSB

UnitedLinux: A Standard or a Distribution?

UnitedLinux, a Divisive Weapon for Caldera's Darl McBride -- Part II

Holger Dyroff, Gaël Duval, Mark de Visser and Mike Angelo Discuss LSB, UnitedLinux, and the Linux Market

UnitedLinux, a Divisive Weapon for Caldera's Darl McBride -- Part I

Netscape Communicator 4.8

Scott McNeil Discusses LSB

New Mozilla Roadmap Kills Mozilla 1.0.x

Mozilla 1.0 Browser-Suite's E-Mail & News Quick Look

Mozilla 1.0 Browser Quick Look

Mozilla 1.0 Browser-Suite Performance -- Speed, Stability, and Memory Hogging

Mozilla 1.0 is Officially Out!

Some Mozilla 1.0 Browser-Suite Annoyances, Bugs, And Issues

Mozilla 1.0 Not Ready for Prime Time -- Close but No Cigar and No Brass Ring!

Turmoil in MozillaLand:

Mozilla 1.0 Browser Sneak Release

AbiWord 1.0.1 Quick Look - MS Word Clone for Linux, MS Windows, & More

MozillaQuest Magazine 2001 Editor's Choice Hardware Picks

Getting Started with Wireless Network Technology

Part III: Adding Wireless to a Linux-Based Laptop or Notebook

Is Mozilla Actually AOL-Netscape's Mozilla?

Bugzilla 2.16 - 2.14.1

Year 2001 in Review -- Mozilla and Netscape Browsers

Free Software for Your New Computer -- Or Any Computer

Linux Gifts for Christmas, Holiday, and All Occasions