Latest articles and Revisions

Spreadsheet

Working with Spreadsheets, cells and formulas

Recent experience with spreadsheets made me think it might be useful to explain to non users just how easy it is to use the features that are available with spreadsheets to log whatever data you wish. To show how brilliant spreadsheets can be I propose to explain how they can be used to keep track of say your bank account with a fully automated balance.

Spreadsheet terms

Spreadsheets - glossary of terms

Lets start by giving you some definitions of what you will see when you start an Open Office spreadsheet. It helps if you know the correct name for each tool and function.

Spreadsheet Active Cell

The Active Cell is the cell that you have selected. To work in a spreadsheet you need to have a cell active. This tells the computer where you want to work.

Spreadsheet precedence

Spreadsheet calculations - Order of Precedence

Formulas containing more than one arithmetic operator follow the order of precedence. A spreadsheet performs its calculations based on the following order:

  • Brackets
  • Order (e.g. Exponents or powers)
  • Division
  • Multiplication
  • Addition
  • Subtraction

One way to remember this is to remember the word BODMAS spelt out by the initial letters.

Brackets have the highest precedence (or priority) while subtraction has the lowest.

Layout guide for novices

Formatting Drupal content

This page is provided as a guide for novice users, unfamiliar with HTML and CSS. It illustrates some very simple editing to show how to enhance the layout of a page. As well as standard HTML, some additional functionality is built into to theme to simplify the task of formatting, and to give the pages a consistent look and feel.

SoSLUG Banner Competition

Outline of Competition

You may have noticed, we recently upgraded the SoSLUG theme. One key feature of the new theme is the banner at the top of the page changes, depending on the page and section of the menu you are currently viewing. At present though quite a few sections do not have their own banner and so the default banner of a jigsaw, with a piece missing is used instead (see below for example).