logo

The Monthly Edition
Of The

k-Byte
Newsletter
Cover Art
v. 25, n. 4, April 2008 Users Helping Users
   

Contents
  1 Moving on to Vista - Part 4 - Neil Stahfest
  2 About k-Byte
  3 All Computers Wait at the Same Speed - Vinny La Bash
  5 Vista Capable??
  5 The New, The Best, and The Worst - Do You Ubuntu (yet)? A Linux Update - Pim Borman
  6 Calendar of Events
  7 The Two Month Activities Calendar
  9 It's Not Just Entertainment Any More - Gene Komarom
  9 Photo Gallery
10 Tip of the Month - File Layout for Excel Databases - (Part 1)
10 About Trading Post
12 Directions and Map to Meeting Place
12 FRPCUG Contacts


Meeting Previews on Page 6:

April: OLPC Hardware Demo and Update

May: Personal Information Managers

APCUG Logo

Quote of the Month

Of all the tyrannies on human kind, the worst is that which persecutes the mind.
John Dryden [1687]


Moving on to Vista - Part 4
by Neil Stahfest, Librarian, Tacoma Area PC User Group, Washington, <http://www.tapcug.org>, ncstahfest(at)msn.com

Windows Vista is a resource hog. A year ago, when I reviewed Vista for TAPCUG, my advice was to not upgrade an existing computer and buy Vista, wait and get it with a new computer. Today I stand by that advice. There are no new major programs that require Vista to run. If you're content with the way your existing computer(s) run with Windows XP there is no real reason to upgrade.

When you do buy a new computer there are several features you should look for it to run Vista well. The first is RAM (random access memory). I don't think any manufacturer is selling a new computer with Vista with less than 1 gigabyte of RAM but if you really want Vista to work well with large applications (Microsoft Office, video editing software, many games) try to get 2 gigabytes of RAM. You won't be sorry. There is no point in installing more than 4 gigabytes of RAM. Windows cannot access memory above 4 gigabytes.

The other issue is a video card. Vista wants at least 128 megabytes of memory for video. For best results, the memory should be installed on the video card. Some computers steal the video requirements from your computer's RAM. It works but the card will run slower. 256 megabytes of video card memory is even better.

Many people don't partition their hard disks, I do. I suppose it goes back to the days when larger hard drives started to appear and our computer operating system couldn't recognize and use the larger space. Of course all that has changed now, Windows can almost any hard drive size most of us will install. When I had to partition my hard drive, to fully utilize it, I discovered other benefits. Its easier to make a backup copy of a smaller hard drive. If I create a partition for just my photographs, and I only need to make a new backup of my pictures, I can just backup the partition containing the pictures and not everything else. A faster and easier process. I can also install another operating system Windows XP or maybe Linux) on my computer by creating a separate partition and run it using a simple process called dual booting.

So I wanted to partition the hard drive that came with my laptop to use some of the excess space to store a backup copy of drive C. I bought a new copy of Partition Magic. I've used this program many times to partition drives on other computers. Unfortunately I discovered that Vista doesn't like Partition Magic. A trip to Symantec's home page showed that they have no updates for Vista. As I was wondering how I would solve this dilemma, I discovered that Vista has a new built-in Disk Management utility and one of its functions will partition hard drives.

To use the utility you first have to get to the Disk Management window. From the start button, go to the control panel. Click on System and Maintenance and scroll down to "Create and format hard disk partitions", at the very bottom of the window. You will see what appears to be a table of every disk and partition installed on your computer. Among other things you'll see the capacity of each disk and the free space available. Select the hard drive that you want to partition and right-click on it. You need to free up empty space on the hard drive so on the drop down menu. Select "Shrink Volume" and specify the amount of space you want to free up in the Shrink Dialog box. The free space will appear in the Disk Management window as a black bar and labeled as "Unallocated".

Now you are ready to create your new partition. Right-click on the "unallocated space". From the menu select "New Partition". Then you just follow the wizard that appears to select the size and type of partition you want to create and format it. It may sound complicated but if you follow the steps listed above its easy.

Windows assigns drives (hard drives, DVD drives, etc) in alphabetical sequence so if drive letters C, D and E were already used your new partition will be labeled drive F. Typically, when you buy a computer from a company such as Hewlett Packard, drive C will be your hard drive, drive D will be a partition labeled "Recovery Drive" (used to restore your computer to "factory condition" in the event of a catastrophic crash) and drive E will be a CD/DVD drive.

Its a cosmetic thing but I like to group all my hard drives and partitions together. You can use the Disk Management window to relabel your drives. Just select one of the drives, right-click on it and select "Change drive letter and paths". When you left-click on "Change drive letter and paths" press the "Change" button and pick a new letter to label the drive. I usually start by re-labeling the Recovery Drive drive "R" to make the letter "D" available for a new hard drive or partition. Then I re-label the CD/DVD drive drive Z. When this is done, all the letters from D through Q are available for hard drives, hard drive partitions and flash drives.

Obtained from APCUG with the author's permission for publication by APCUG member groups. This article has been provided to APCUG by the author solely for publication by APCUG member groups. All other uses require the permission of the author (see e-mail address above).
Article end
Back to the Top
About k-Byte

Published monthly, k-Byte is the official newsletter of the Front Range Personal Computer Users Group (FRPCUG): our mailing address is PMB 152, 305 W. Magnolia, Fort Collins, Colorado 80521.

Opinions expressed in k-Byte are those of the authors and do not necessarily reflect those of the group or its members. Publication of information in k-Byte constitutes no guarantee of accuracy. Use of any information found in this publication is at the sole risk of the user. Neither k-Byte, nor its officers, nor its editors or contributors assume any liability for damages resulting from use of information in this publication.

Submissions

Articles, letters and short items of interest on computer-related topics are welcome and encouraged. All items submitted for publication are subject to editing. Send your contribution to the editor via e-mail attachment or submit on disk. If you have questions about a submission, please contact the editor for information.

Copyright and Trademark Information

k-Byte is copyrighted ©2008 by the Front Range Personal Computer Users Group. The k-Byte logo and the Front Range PC Users Group logo are Trademarked by the Front Range PC Users Group. Unless otherwise noted, other nonprofit users groups may reprint or quote from any articles appearing in k-Byte without prior permission, provided that: a) proper author and publication credits are given; b) that a copy of the publication in which the article appears is sent at no cost to k-Byte at the above mailing address, or emailed to contact(at)frpcug.org; and c) any additional instructions/restrictions contained in the article are followed. User groups wishing to exchange newsletters with FRPCUG are invited to send a copy of their newsletter together with an exchange request.

Disclaimer

IBM PC, OS/2, Compaq, HP, Dell, UNIX, Windows and other trademarks occasionally mentioned in k-Byte are registered trademarks of International Business Machines, Inc., Hewlett-Packard Corporation, Microsoft, Dell Inc., or their owners respectively. Neither FRPCUG nor its newsletter k-Byte are connected in any way with any manufacturer or seller. Acceptance by FRPCUG of donated products or services from suppliers, or inclusion of a supplier in the FRPCUG Partner list does not imply that any continuing financial support is received or expected by FRPCUG. Nor do such activities imply an endorsement of either the supplier or product or service. Such information is made available to members as a service. Use of any product or supplier found in this publication, or any FRPCUG publication, is at the sole risk of the user.

Advertising

Classified advertising is free to members for non-business ads. See "About Trading Post" for pricing for camera-ready display ads. Charges for ad makeup from sketches, etc., are available on request. Deadline for camera-ready and classified ads is 45 days prior to the month of publication. For example, ads for the March newsletter must be submitted by January 15th. For pricing and schedules for ad design, connect to contact(at)frpcug.org or kbyte(at)frpcug.org.

About FRPCUG

FRPCUG is an independent nonprofit computer society, so incorporated with the State of Colorado and open to anyone interested in Windows, or UNIX/LINUX microcomputers. Its purpose is to provide an educational and scientific forum of mutual benefit for members of the micro-computer community. FRPCUG holds a monthly meeting and conducts various special interest groups (SIGs) and seminars. Members have voting privileges, subscription to k-Byte newsletter, and access to SIGs and selected seminars. Annual dues are $25 for individual/family membership ($20 for students) and $50 for corporate/group membership.
Article end
Back to the Top
All Computers Wait at the Same Speed
by Vinny La Bash, Member of the Sarasota Personal Computer Users Group, Inc., Florida, <http://www.spcug.org>, vlabash(at)comcast.net

I first heard that phrase about ten years ago at a geek conference in Seattle. A decade ago is earlier than the Stone Age in computer years. It was probably meant to make fun of the propeller heads that couldn't live without the fasted CPU on their motherboard. The geeks' concern with processing speed seemed ridiculous to those who understood that computers spend very little of their time processing information. They spend it waiting for us to tell them to do something. You would certainly find your life very boring if you had to spend 99% of your time waiting for other people to act before you could do anything.

What are we talking about? We're talking about keeping your system properly tuned so that you don't have to wait while it tries to do its job. It's no secret that Vista has had performance problems. Microsoft has promised that their upcoming service pack should resolve most if not all performance issues. We've heard similar kinds of promises from Redmond before, but this time they say they really mean it. In fairness, not every performance issue can be laid at Microsoft's doorstep, but it's always fun to blame them because they're such an easy target.

Vista puts great demands on your CPU due to Aero and other assorted graphical gizmos built into the product. They should have named it the Eye Candy OS. Responding to the user community, Microsoft also added security features and additional functions that were not present in XP. When you ask your CPU to do more, you're adding overhead. This means you need more CPU power or you live with a slower system. If Vista performance has been less than stellar, the good news is that you can do something about it other than buying a new computer. Here are some of the things you can do to make Vista more appealing from a performance standpoint.

You're probably tired of hearing this one. It's like mother telling you to eat your vegetables. You know she's right, but you don't want to hear it. ADD MORE MEMORY. Vista is hungrier for RAM than any of its predecessors, and with memory as cheap as it is, it doesn't make sense to keep it on a starvation diet. XP runs great on one gigabyte of RAM. Vista should have two gigabytes as a minimum, and you won't go wrong by installing even four gigabytes.

Even with enough physical memory, Vista can still act like a tired old dog if you have a lightweight video card. Go into the Performance Information and Tools utility in Control Panel, and check out your video card with the Windows Experience Index. You need a video card that's certified for Vista Premium and supports Direct X 10. Use the money you save on RAM to buy a good video card. Don't try to do this one on the cheap.

A real help to good performance is bringing your power settings to the High Performance option. Do this from the Power Options utility in Control Panel. The default setting is Balanced which is OK for XP but not Vista. The High Performance setting gives you full access to all the Power in the CPU.

Turn off the sidebar. While this feature is visually appealing, it has few socially redeeming traits. Turning off this feature can sometimes result in significantly faster startups and shutdowns. Disable the sidebar by right-clicking it. Select Properties, and remove the checkmark in the box that starts the sidebar when Vista wakes up.

Fine tune your indexing options. Vista has a great search feature, but it's totally dependent on indexing the files and programs on your hard drive. It's a mixed blessing. You have a fantastic search capability when you index all locations, but you take a performance hit. By indexing fewer areas, performance will improve, but your search feature will be less robust.

Vista won't let you turn off indexing completely, but you can disable indexing for locations that may not be important to you. Do this from the Performance Information and Tools utility in Control Panel.

Here's another "eat your veggies" type tip. Empty the Recycle Bin and adjust it so it doesn't take up more than 2% of your hard drive. Right click on the Recycle Bin, select Properties, and make the necessary adjustments in the dialog box. Don't forget to defrag your disk once in a while, and empty the Recycle Bin before you defrag, not after.

Open My Computer from the Desktop. Right click on the C: drive, select Properties and check how much space you have left on your hard drive. If you're approaching 90% or more, you need to take non-essential files and move them to another location. Vista needs free disk space to perform certain housekeeping functions, and if it has to hunt around for room or use virtual memory, your performance hit could be enormous.

Keep your device drivers up-to-date. Device drivers were designed to ensure that programs or hardware peripherals could "talk" to the system without problems and do their jobs properly. Newer drivers can improve 3D performance, fix bugs and other graphical glitches in games and video programs. Device drivers can avoid memory conflicts and prevent programs from squabbling over resources. Newer device drivers can support innovative features within applications, and ensure compatibility among different programs.

These are only some of the things you can do to improve Vista performance. Removing unnecessary startup programs, preventing spyware and virus infections, and updating old software are additional steps you can take. If your system is frequently hanging up or crashing after doing everything you can do to improve performance, then it's time to consider reformatting your hard drive and reinstalling everything, but that's another article.

Obtained from APCUG with the author's permission for publication by APCUG member groups. This article has been provided to APCUG by the author solely for publication by APCUG member groups. All other uses require the permission of the author (see e-mail address above).
Article end
Back to the Top
Vista Capable??
Contributed by Bert Broekstra, Front Range PC Users Group, http://www.frpcug.org

For those of you that bought what you thought was a "Vista Capable" computer, and discovered it wasn't, check out these links:

Microsoft e-mails detail Vista woes (http://www.news.com/8301-13860_3-9882192-56.html )

Microsoft Eased "Vista Capable" Specs So Intel Could Meet Quarterly Numbers (http://www.informationweek.com/news/showArticle.jhtml?articleID=206900863 )

The second article describes a class action lawsuit against Microsoft claiming deceptive marketing practices.
Article end
Back to the Top
The New, The Best, and The Worst
Collected by Pim Borman, Webmaster, SW Indiana PC Users Group, Inc., <http://swipcug.apcug.org/>, swipcug(at)gmail.com

Do You Ubuntu (yet)? A Linux Update

In February of 2002 I wrote:

"It has been said that Windows XP is less buggy than its Windows 95, 98, and Me predecessors; damnation by faint praise. XP is also more expensive, can only be used on a single computer, and presents many incompatibilities with existing hardware and software. It hogs resources. That led me to wonder how Linux is coming along."

Replace "XP" with "Vista" and history repeats itself. Furthermore, add that online security has dramatically worsened and that the security of Windows Vista is at best only marginally improved.

At the time I got a copy of the Red Hat Linux 7.2 distribution (list price $60), included in a 1000+ pages "Linux Bible" and proceeded to evaluate it. I found that the limited software included in the distribution was nice and useful, but trying to install additional programs from the Internet was a nightmare.

Six years later desktop Linux has matured beyond recognition. Lindows, later renamed Linspire, was the first distribution making it a one-click operation to download and install software from a large online library. Originally the cost of acquiring Linspire and a one-year subscription to the library was $100, but more recently the service has been available for free. I am still using an older version of Linspire daily, mostly for Web browsing, accessing email, and playing Freecell, Yukon or MahJongg.

In 2004 Marc Shuttleworth, a South African by birth, started a free new Linux distribution called Ubuntu ("humanity towards others"). In 1999 he sold Internet security software he had developed to Verisign for about $575 million. He spent $20 million of that on an 8-day trip by Soyuz to the Space Station and had plenty left over for a free software project. By now Ubuntu has become the most advanced and popular desktop Linux distribution, with the help of numerous volunteer contributors.

Ubuntu undergoes continuous upgrades as new and improved software is being developed and tested. Twice a year, in April and October, a new version is released. The latest version is numbered 7.10, for October of 2007, and is nicknamed "Gutsy Gibbon." (The next issue in April, version 8.4, will be named "Hardy Hero." You get the drift).

I installed Ubuntu side-by-side with Windows XP on my desktop computer, equipped with an AMD Athlon64 X2 4800+ dual core processor, 1 GB of RAM and an nVidia GeForce 7600 graphics card. I put it in a separate Linux partition on my hard drive previously used for Linspire. Before committing to the installation I ran Ubuntu off the CD to verify that it was compatible with my hardware.

Once installed, Ubuntu was ready to go. It automatically set up my connection to the Internet with Firefox, and with my permission downloaded a large number of updates and additions released since October. The OpenOffice.org suite of programs, comparable to MS Office, was ready to go. I already had been using the Windows version of OpenOffice Writer so there was no learning curve whatsoever. The Gimp, an advanced graphics program similar to Adobe Photoshop Elements and with comparable features, came preinstalled. I also found drivers for my HP 812C printer and my Epson Perfection 3490 Photo Scanner. With all the necessary tools at hand I had no difficulty producing the January newsletter, including typing the articles, downloading articles from other user groups, and designing the layout and the new masthead. I printed the newsletter ready for Xeroxing and used OpenOffice Writer to save a separate version (omitting treasury data) to pdf format for distribution on the Internet.
Ubuntu provides many additional Linux programs:
  • Thunderbird, well-known program.
  • Pidgin, an Messenger graphical multi-protocol instant messaging client, capable of using AIM/ICQ, Yahoo!, MSN, IRC, Jabber, Napster, Zephyr, Gadu-Gadu, Bonjour, Groupwise, Sametime, SILC, and SIMPLE all at once.
  • GRAMPS, genealogy program capable of GEDCOM files that are used in such programs as FamilyTree Maker for Windows. It can produce reports in various formats, such as text, HTML and PDF.
  • Gnucash can track finances in multiple accounts, keeping running and reconciled balances. It has a graphical user interface, double entry, a hierarchy of accounts, expense accounts (categories), and can import Quicken QIF files and OFX files.
  • Multiple sound and video programs for burning and reading CDs and DVDs, ripping and creating audio CDs, recording sound clips, playing movies, etc.
  • Popular games, including aisleriot (anagram of solitaire),a large collection of card games, including Freecell. Also blackjack, glchess, gnome-sudoku, gnometris (Tetris), gnomine (minesweeper), mahjongg, and many others.
Additional programs can be installed with the Add/Remove function. Some powerful Linux programs that are not (yet) specifically adapted for Ubuntu can be retrieved with the Synaptic package manager, an easy-to-use graphical program to download applications from the Internet. I used it to download and install Scribus, an advanced desktop page layout manager capable of producing commercial grade output in PDF and Postscript. Difficult to use for a non-professional, but it worked just fine.

Installation

It is easy to install Ubuntu and Windows on the same computer in separate partitions. Previously that required manually repartitioning your computer with a program such as Partition Manager, but the latest Ubuntu version, Gutsy Gibbon, includes its own Linux-based partition manager, GParted, and automatically uses it to scan your computer for available space and to reconfigure that space (with your approval) to install itself. During boot-up the computer displays a menu of startup options, including Windows or Ubuntu.

I evaluated the ease of installation on an old Dell Inspiron 3800 laptop computer, with a 600 MHz Celeron CPU, 320 MB RAM and 880MB free disk space. Installation alongside the existing Windows Me went flawlessly. The computer didn't have a network card, but Ubuntu recognized the PCMIA wireless network card and connected to the Internet after I provided the router parameters.

"Sounds Great, But Why Bother?"

For the same reasons people move out of the city to the suburbs: security and cost-of-living. To enjoy the best of both worlds, install Ubuntu side-by-side with a basic Windows program. No need for expensive MS Office or Adobe programs. Use Ubuntu for safe online access, and keep Windows for those few occasions were Linux does not (yet) provide the means. As time goes by, it will probably be possible to abandon Windows altogether. Give it a try!

Obtained from APCUG with the author's permission for publication by APCUG member groups. This article has been provided to APCUG by the author solely for publication by APCUG member groups. All other uses require the permission of the author (see e-mail address above).
Article end
Back to the Top
Calendar of Events

April General Forum Meeting

We will meet at the Fort Collins Senior Center on Tuesday, April 1st 7:00 PM

Meeting Agenda:

7:00 to 7:15 Announcements
7:15 to 8:00 Open Forum
8:00 to 8:15 Break
8:15 to 9:00 OLPC hardware Demo and Project Update

2008 Graphical Events Calendar

SPECIAL ANNOUNCEMENT: Digital Imaging Clinic
Rick Mattingly has scheduled an encore of his Digital Imaging Clinic. The clinic is scheduled for April 19th from 8:30 AM to 12:30 PM in Acitivty Room 2 at the Fort Collins Senior Center. Sign up at the April General Meeting or contact Rick directly at rickmatt(at)q.com

May General Forum Meeting

We will meet at the Fort Collins Senior Center on Tuesday, May 6th 7:00 PM

Meeting Agenda:

7:00 to 7:15 Announcements
7:15 to 8:00 Open Forum
8:00 to 8:15 Break
8:15 to 9:00 Personal Information Managers

See you at the meetings!

Get full membership benefits. If you are not a current member, download an application from http://www.frpcug.org/memberap.htm

Future General Forum Meeting Notes

The One Laptop Per Child (OLPC) computer will be demonstrated at the April General Forum meeting. This unit is an example of outstanding engineering. It is rugged, simple and easy to use, with far more capabilities than you would expect. Come to the meeting to see it in action, and get an update on the project.

It's not just a telephone anymore (my apologies to Gene Komaromi--See page 9). The May General Forum meeting will offer a current view of Personal Information Managers. If your question is: "Are you talking about my 'Blackberry(TM)'?" Well . . . maybe. Come to the meeting and find out.

And . . . don't forget the Digital Imaging Clinic on April 19th.

Future SIG's, Seminars, and Other Meetings

Digital Imaging SIG

The NEW Digital Imaging SIG is a forum for discussion of digital imaging hardware and software. The meetings are held every 2nd Tuesday of the month at 7:00 PM in the Senior Center Lobby. The meeting format is informal, using the Shop Talk sessions as a basis. For more information, contact Mike Morris at twriterext(at)gmail.com.

Desktop Publishing SIG

The DTP SIG is a forum for discussion of desktop publishing applications. The meetings are held every 3rd Wednesday of the month at 7:00 PM in the Senior Center lobby. The meeting format is informal, using the Shop Talk sessions as a basis. For more information, contact Mike Morris at twriterext(at)gmail.com.

New Technology SIG

The New Technology SIG provides advance support for all PC related operating system and telecommunication issues. The meetings are held at 7:00 PM on the third Thursday of each month at Bluebird Manufacturing Inc., 1421 Webster Avenue, in Fort Collins. For more information, contact Chuck McJilton at 970-493-2987.

Shop Talk

One-on-one assistance. Drop in to the Senior Center lobby on any Saturday (holidays excepted) from 11:00 AM to 1:00 PM

Board Meeting

FRPCUG's executive board meets on Wednesday of the week following the General Forum meeting. All members are welcome and are encouraged to attend. These meetings are held at 7:00 PM in the Staff Board Room of the Fort Collins Senior Center.

Back to the Top
April 2008 - Graphical Events Calendar

 1 FRPCUG General Forum Meeting 7:00 PM
 5 Shop Talk 11:00 AM to 1:00 PM
 8 Digital Imaging SIG Meeting 7:00 PM
 9 FRPCUG Board Meeting 7:00 PM
12 Shop Talk 11:00 AM to 1:00 PM
16 DTP SIG Meeting 7:00 PM
17 New Technology SIG Meeting 7:00 PM
19 Shop Talk 11:00 AM to 1:00 PM
26 Shop Talk 11:00 AM to 1:00 PM

May 2008

 3 Shop Talk 11:00 AM to 1:00 PM
 6 FRPCUG General Forum Meeting 7:00 PM
10 Shop Talk 11:00 AM to 1:00 PM
13 Digital Imaging SIG Meeting 7:00 PM
14 FRPCUG Board Meeting 7:00 PM
15 New Technology SIG Meeting 7:00 PM
17 Shop Talk 11:00 AM to 1:00 PM
21 DTP SIG Meeting 7:00 PM
24 Shop Talk 11:00 AM to 1:00 PM
31 Shop Talk 11:00 AM to 1:00 PM

Back to the Top
It's Not Just Entertainment Any More
by Gene Komaromi, a member of the Computer Club of Green Valley, Arizona
<http://gvcc.apcug.org/> genek6(at)gmail.com

In the past, we've commonly thought of computer games, especially those played on game machine platforms, as pure entertainment. Times have changed and many games have become educational as well as physical training devices.

Learning has become fun for both kids and adults. Here's some information that will keep you ahead of the digital gaming curve.

DS - Handheld Games for Senior Citizens

Double Screen Nintendo has a hot selling hand held video game machine called the "DS" for "Double Screen." The device opens with two visible screens, one is a display screen and the other is a "Touch Screen" which serves as the controller interface. The DS has a series of games designed with "older" users in mind. They are Brain Age, Big Brain Academy and Flash Focus.

All three have been recommended by AARP, and Brain Age has been shown to improve mental performance in independent tests. Brain Age and Big Brain Academy have a series of games, practice exercises and tests that are designed to improve and evaluate cognitive skills, and best of all "they're fun." They chart and graph improvement and will keep records for several individuals.

Have you ever had a problem with that vision test on your driver's license exam? Then Flash Focus was made for you. It too has games and exercises, but instead of improving your brain they improve your eyes.

Wii Want to Play
The hottest new gaming console is the Wii, another product from Nintendo that has games designed for the older kids, real older kids. The game controller is a little motion sensitive device that straps on the user's wrist. Participants interact with the game by moving their arms.

In the Detroit area, aerobic classes and movies have been replaced by Wii in many senior citizen centers. "Bowling" seems to be one of the most popular games. I've played it, and yes, it's exactly like the real thing. The motion of your arm, as you approach a virtual bowling alley, allows you to curve the ball and add some spin. Wii bowling leagues are springing up all over the country. Nintendo is about to release an exercise program for the Wii that uses a floor pad as a controller.

Obtained from APCUG with the author's permission for publication by APCUG member groups. This article has been provided to APCUG by the author solely for publication by APCUG member groups. All other uses require the permission of the author (see e-mail address above).
Article end
Back to the Top
Sombrillas
Photo Gallery

This month's featured photographer:

Paul Ostrof, using a Leica DLUX2

Sombrillas (A View of Umbrellas)


Article end


Back to the Top


Tip of the Month

File Layout for Excel Databases (Part 1)
Courtesy of, and Copyright 2007 by The Office Experts. Reprinted with permission. Examples added by editor.

Most people use Excel for the purpose of having a database of information or for financial purposes. We recently saw a document from a very large corporation that contained financial reports, one on each page. What a mess! How much easier it would be to do all of your calculations, and data entry on one sheet. Then, create a Word document and copy the cells from Excel and Edit/Paste special/Paste link so that your reports are updated when you change your Excel data.

The absolute best file layout for using Excel and its features is as follows:

Column headings (call them field names if you like) are in Row 1
First record is in Row 2
No completely blank rows in your data
No completely blank columns in your data

This layout allows you to use the features of Excel as they were intended to be used. Many people never discover the features because their files are not set up in this manner, the feature doesn't work the first time they try it, and they forget about it. Don't stop trying! You'll find that the things you're doing manually every day might easily be accomplished with one of Excel's features. If you're unsure, ask at the Forum!

Here is a sample of a typical spreadsheet layout (I have used Quarters instead of Months for demonstration purposes):
Standard

Those blank rows and columns can be a problem when sorting, filtering or grouping data, or using pivot tables.

"But I don't sort or filter or group the data," you say. "I just want a simple report of expenses (or revenue, or . . .)." Perhaps that is the case. Remember that the objective of the report is to communicate information (and, in the case of financial information, important information). It is worthwhile to investigate and learn these additional features. Talk to any experienced spreadsheet user, and you will discover just how valuable those reporting features can be. There are always questions that can be answered much more easily using these features than not.

Here is an example of a better layout:
Preferred

OK, OK, I can hear the howls of protest from here! No one, you say, publishes financial reports in that layout. First, that is not always the case. Second, you can create a more "traditional" summary layout, if you really need one, with a few simple mouse clicks. More on this next month. You may find that, if you use these reporting features, you don't need row 6.
Article end

Back to the Top
About Trading Post

Noncommercial Advertising

k-Byte runs classified ads in Trading Post for three consecutive issues. Trading Post ads up to 10 lines (or 70 words) long are free to FRPCUG members and only $10 for non-members. To place an ad in Trading Post contact Rick Mattingly at 970-613-8968 or e-mail to rickmatt(at)q.com.

Commercial Advertising Specifications (Per Issue)

Full Page (8.5" x 11")*$50.00
Half Page (5.5" x 8.5")*$30.00
Quarter Page (4.25" x 5.5")*$20.00
Business Card (2" x 3.5")*$10.00

We ofer a substantial discount for repeat ads and continuing contracts. For an additional charge we will design your ad for you. Contact Rick Matingly for more information on this service at 970-613-8968 or email to rickmat(at)q.com.

*Allow for 0.5 inch margins
Back to the Top
Senior Center Map


The Fort Collins Senior Center

The Fort Collins Senior Center is located at 1200 Raintree Drive. This site is situated at the northwest corner of the Shields and Raintree Drive intersection, on the north side of the Raintree Shopping Center, and just west of the bank building on the corner of Shields and Raintree (see map at right).

Check the marquee at the main entrance for directions to the specific meeting room.





Back to the Top
FRPCUG CONTACTS
Telephone Area Code 970
FRPCUG Officers Name Work Home e-mail
President Rick Mattingly 613-8968 rickmatt(at)q.com
Vice President Don Anderson 498-3534 482-0943 doande(at)gmail.com
Treasurer Virginia Febinger 498-2127 gingercln(at)comcast.net
Secretary Jim Bragonier 484-9061 james.bragonier(at)comcast.net
k-Byte Staff
Editor-in-Chief Mike Morris 461-2002 twriterext(at)gmail.com
Features Editor Mike Morris
Other Contacts
Membership Coordinator Jack Linder 663-2151 jack(at)frpcug.org
New Technology SIG Leader Chuck McJilton 493-2987 cdmcjs(at)gmail.com
Digital Imaging SIG Leader Mike Morris
DTP SIG Leader Mike Morris
Publicity Mike Morris 461-2002 twriterext(at)gmail.com
Door Prize Coordinator John Goldey 221-0877 johngoldey(at)juno.com
FRPCUG Fax Line 493-1408
FRPCUG Home Page w/E-Mail http://www.frpcug.org
FRPCUG Officer E-Mail contact(at)frpcug.org
Membership in the Front Range PC Users Group is $25 per year for individuals and $50 per year for companies.
Mail your completed application and payment to:
FRPCUG
PMB 152
305 W. Magnolia
Fort Collins CO 80521
or join in person at the monthly meeting on the first Tuesday of each month.

Web Site

Back to the Top

Valid XHTML 1.0 Strict