skip to main content - dyslexic font - mobile - text - print

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes Monday through Friday.

In-Depth Series

LibreOffice

In this in-depth series on LibreOffice

30 - LibreOffice Calc - A Savings Model - Ahuka | 2014-06-06

In the previous tutorial we discussed the fundamental ideas of building models and doing “What-If?” analysis. Now we need to take these ideas and put them into practice so you can see how this works. To do this I will create  a simple model of savings over time. Now, I do want to be clear that this is a very over-simplified model and should not be taken as a good predictor of actual results. The idea is to illustrate the techniques involved in building a model and doing “What-If?” analysis.

So. what are the variables, parameters, assumptions, etc. that we need? I have identified these in my model:

  • An initial amount of money already saved. This is the starting amount you have.
  • An amount of money you add to your savings each year.
  • The rate of return on your savings

For the remainder of the show notes please see http://www.ahuka.com/?page_id=761

A copy of the spreadsheet created for this program can be found at http://www.ahuka.com/?attachment_id=763

29 - LibreOffice Calc - Models and "What-If" Analysis - Ahuka | 2014-05-23

The next topic is extremely important because it addresses where most beginning users of spreadsheets get into trouble. First, understand that building models and doing "What-If" analysis is fundamental to the success and widespread adoption of spreadsheets all over the world. A model can be thought of as a mathematical representation of a process of some kind. It could be financial, such as projecting my sales over the next year, or perhaps working out when my car loan will be paid off. Or it could be scientific, such as projecting out the reaction times and quantities in a chemical reaction. The only real requirement is that whatever you are modeling has to be something that can be represented using mathematical formulas of some kind.

"What-If" analysis takes this model and lets you experiment to see how how changes in different variables affect the results in your model. If I am figuring out when my car loan will be paid off, I might ask how paying an extra $20 per month against the principle would affect my results (presumably, it should lead to getting it paid off sooner if I set the model up correctly.) Or in the case of the chemical process, how would different temperatures or pressures affect the reaction times and quantities? By experimenting with different values in my model I can do this comparison easily. But only if I built the model properly in the first place.

For the remainder of the show notes please see http://www.ahuka.com/?page_id=752

28 - LibreOffice Calc - Fills, an Introduction - Ahuka | 2014-05-09

Hostname and email address: Ahuka ahuka@ahuka.com Show Title: Ahuka - 28 - LibreOffice Calc - Fills, an Introduction Desired Slot: Episode Number 1505 Intro and Outro Added: YES Series/Tags: LibreOffice, Calc, Spreadsheet, fills Explicit: Clean Twitter/Identi.CA Summary: This episode looks at the filling rows and columns using click-and-drag.

One of the key techniques in using a spreadsheet is to master the art of fills, which lets you fill a column or a row with data without having to type in every cell individually. And this technique requires that there be a predictable pattern to the contents of each cell as you fill them. But you can do a lot with this technique, and we will want to use this when we do our first model, which will be a simple savings model.

But first we need to build the tools in our tool kit, and fills are a big one. To begin with, you can fill either rows or columns, though columns are more frequently filled using this technique. Still, it is good to know you can do either. The simplest fill begins with a cell that has some kind of contents. For example, lets say that cell B1 contains the word "Rain". If you click on the cell, you will see it highlighted with a thick black border

For the remainder of the show notes please see http://www.ahuka.com/?page_id=734

27 - LibreOffice Calc - Calculations and the Formula Bar - Ahuka | 2014-04-25

Since the main purpose of a spreadsheet is to perform calculations it is appropriate that we consider just how this is done.

In general, a cell of a spreadsheet can contain one of three things:

  • A number
  • Text
  • A formula

All calculations are done using formulas. A formula occurs whenever a cell has contents that begin with an equals sign, which is the signal to Calc that it needs to perform a calculation. For instance, if a cell contains "A3+B3", Calc would examine this, see the letters and the plus sign, and decide that the contents of the cell were a text string. After all, it cannot be a pure number with those other things there. But place an equals sign in front, so that the contents now read "=A3+B3" and Calc knows that this is formula, and will perform the calculation. And one of the best ways to interact with a cell that contains a formula is to use the Formula Bar, which normally appears just above the cells of the spreadsheet proper:

For the remainder of the show notes please read: http://www.ahuka.com/?page_id=723

26 - LibreOffice Calc Cells - Ahuka | 2014-04-11

LibreOffice Calc: Cells

All spreadsheets have the same basic structure, a table of rows and columns. Columns are headed up A, B, C, and so on. After Z, the next column is AA, then AB, AC, AD, and so on. The maximum number of columns is 1024. Rows are numbered 1,2,3 and so on, and the maximum number of rows is 1024*1024, or 1,048,576. At this time I am not aware of any plans to increase these numbers, though that could change if competitive pressures make it necessary.

Where a row and column intersect, there is a cell, which is given the address of the column followed by the row, e.g. A1, but never 1A. This is very useful since you can use the contents of a cell in a calculation by simply using the cell address. For example, to add the value of cell B4 to the value in cell C3 and store it, you would write “=B4+C3″ in the cell where you want to store the sum. Learning to use cell addresses is extremely important, so get in the habit of doing this at every opportunity.

For the rest of this article see http://www.ahuka.com/?page_id=706

25 - LibreOffice Calc What Is A Spreadsheet - Ahuka | 2014-03-28

LibreOffice Calc: What is a Spreadsheet?

There are different ways to answer this question. Functionally, spreadsheets are a tool for mathematical calculations, but have branched out into related areas like data analysis. Some people even use them as a quick-and-dirty database tool. If you are in a financial profession of some kind you probably live in spreadsheets all day.

Spreadsheets are original “killer app”. Early examples were implemented on mainframe computers in the 1960s, but the big step was the creation of VisiCalc for the Apple II in 1979, which was then ported to the IBM PC in 1981. VisiCalc set the conventions that guided all subsequent spreadsheets, and the essential methods have not changed since then. VisiCalc was called the first killer app because people would buy the computer just to run the program, and the usefulness of spreadsheets is what promoted the initial entry of personal computers into the corporate world, with all of the change that has caused.

For the remainder of this article please see http://www.ahuka.com/?page_id=699

24 - LibreOffice Writer A Brochure Project - Ahuka | 2014-03-14

The written version of this show can be found at http://www.ahuka.com/?page_id=676 The European version of the brochure. The American version of the brochure.

23 - LibreOffice Writer Other Page Layout Options - Ahuka | 2014-02-28

Other Page Layout Options

As we mentioned in beginning our look at Page Layout, you have some options other than just Page Styles and Frame Styles, useful though they are. So let’s spend a few moments looking at these other options and see how they work.

Tables

Tables can be a useful tool for more than just displaying tabular data. You can place different object in each cell of a table and so have some control over how things are laid out on the page. You could, for instance, place your sub-heads in a left-hand column, and the associated text in an adjoining column, which gives you the same effect as using the Marginalia style. And you can add pictures, charts, and other objects as well. You can even insert a table into a cell of another table to get more fine-grained control. In fact, in the days before Cascading Style Sheets and Javascript, tables were the primary way of laying out Web pages, though these days that is frowned upon, and in any case most Web pages are now created using some kind of CMS software like WordPress, or Drupal. The idea of using tables was more attractive when we realized you could turn-off the cell borders and make them invisible. Of course, in Writer documents that only works when they are printed. When opened on a computer the table borders are still visible, as indeed they would have to be for you to edit the document.

For the remainder of this article please see http://www.ahuka.com/?page_id=676

22 - LibreOffice Writer Other Frame Styles - Ahuka | 2014-02-14

This continues our look at frames by looking at frame styles for things other than text.

LibreOffice Writer Other Frame Styles

In the previous tutorial we looked at using the frame style for text, which is not called the Text style, but the Frame style, which may be confusing. This is a very common use of frames, but there are others. To start the discussion, let’s get back to the basic concept of objects. LibreOffice is an object-oriented program and you should keep this in mind when dealing with this software.

A piece of text can be an object, and it can contain other objects (paragraphs, sentences, words, characters), or it can be contained within other objects (section, chapter, document). In the case we are looking at, a frame is an object, which contains other objects, and is in turn contained within larger objects (page, section, document). Depending on the objects being contained, the frame styles can be different, and that is what we need to look at now.

Please see http://www.ahuka.com/?page_id=671 for the rest of the article

21 - LibreOffice Writer Frame Properties Completed - Ahuka | 2014-01-31

This is the second of two programs that look at Frame properties in LibreOffice Writer. In the first program we looked at how to size and position Frames. Here we look at other things you can do, such as name your frames for linking, wrap text around frames, set the borders and backgrounds, and even add columns to the frame. This finishes the look at the Properties window and what you can do there.

Links

This tutorial can be found in written form on my Web site at http://www.ahuka.com/?page_id=652

18 - LibreOffice Writer Working with Page Styles - Ahuka | 2014-01-03

In this episode of our LibreOffice series we take the concept of Page Styles, and show how to use them to create an elegant document.

Some useful sites


My web site is at http://www.ahuka.com/.

This program has a written page at http://www.ahuka.com/?page_id=608


Remember to support free software!

18 - LibreOffice Writer Page Styles Introduced - Ahuka | 2013-12-20

In this episode of our LibreOffice series we introduce the concept of Page Styles, and take a look at how their properties can be controlled.

Some useful sites


My web site is at http://www.ahuka.com/.

This program has a written page at http://www.ahuka.com/?page_id=488


Remember to support free software!

17 - LibreOffice Writer Overview of Page Layout Options - Ahuka | 2013-12-06

In this episode of our LibreOffice series we begin our look at how you control page layout.

Some useful sites


My web site is at http://www.ahuka.com/.

This program has a written page at http://www.ahuka.com/?page_id=478


Remember to support free software!

LibreOffice 16 Writer Nested Lists Controlled via Styles - Ahuka | 2013-11-22

In this episode of our LibreOffice series take the Nested lists and see how we can control them using Styles.

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 15 Writer Nested Lists Introduced - Ahuka | 2013-11-08

In this episode of our LibreOffice series we look at Nested lists, a tricky but powerful techinque to use.

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 14 Writer A Numbered List Style Deconstructed - Ahuka | 2013-10-25

In this episode of our LibreOffice series we take one of the Numbered List styles in LibreOffice Writer and go through the Properties window to learn how it is put together

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 13 Writer A Bullet Style Deconstructed - Ahuka | 2013-10-11

In this episode of our LibreOffice series we take one of the Bullet List styles in LibreOffice Writer and go through the Properties window to learn how it is put together

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 12 Writer List Styles Introduced - Ahuka | 2013-09-27

This episode of the LibreOffice series introduces the concept of List Styles in LibreOffice Writer. We discuss List Styles in general and tour the Properties window for List styles.

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 11 Writer Character Styles - Ahuka | 2013-09-13

Mentioned in the program: http://www.csszengarden.com/

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 10 Writer Paragraph Styles in Templates - Ahuka | 2013-08-30

Mentioned in the program: http://extensions.libreoffice.org/

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 09 Writer Working With Paragraph-Level Styles - Ahuka | 2013-08-16

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 08 Writer Tab Styles - Ahuka | 2013-08-02

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 07 Writer Heading Styles - Ahuka | 2013-07-19

Some useful sites

My web site is at http://www.ahuka.com/.

Remember to support free software!

LibreOffice 06 Writer Creating a Paragraph Style LibreOffice - Ahuka | 2013-07-05

Some useful sites

My web site is at hhttp://www.ahuka.com/.

Remember to support free software!

LibreOffice 05 Writer Style Properties 2 - Ahuka | 2013-06-21

Links

My web site is at http://www.ahuka.com/

Remember to support free software!

LibreOffice 04 Writer Style Properties 1 - Ahuka | 2013-06-11

Some useful sites

My web site is at http://www.ahuka.com/

Remember to support free software!

LibreOffice 03 Writer Introduction to Styles - Ahuka | 2013-02-22

Some useful sites


My web site is at http://www.ahuka.com/.


Remember to support free software!

LibreOffice 02 Writer Default Template - Ahuka | 2012-12-27

Some useful sites

  • http://www.libreoffice.org/get-help/documentation/
  • http://wiki.documentfoundation.org/Documentation/Publications
  • http://gofree.com/Tutorials/
  • http://en.libreofficeforum.org/

My web site is at hhttp://www.ahuka.com/.


Remember to support free software!

LibreOffice 01 Introduction to Office software - Ahuka | 2012-12-10

LibreOffice

Some useful sites


My web site is at hhttp://www.ahuka.com/.

Remember to support free software!

Separate Presentation from Content - 2 Office Software - Ahuka | 2012-10-10

Alfrescohttp://www.alfresco.com/


Ohio LinuxFest is September 28-30 in Columbus, Ohio. Go to https://ohiolinux.org/ for more information.


My web site is at hhttp://www.ahuka.com/.


Remember to support free software!

Separate Presentation from Content - 1 The Web - Ahuka | 2012-09-12

The W3C page on why you should do this: http://www.w3.org/TR/WCAG20-TECHS/G140

The The Universal Usability page: http://universalusability.com/access_by_design/document_structure/separate.html

Wikipedia has an article at: http://en.wikipedia.org/wiki/Separation_of_presentation_and_content

CSS Zen Garden shows how the look of a page can change with the same content : http://www.csszengarden.com/


Ohio LinuxFest is September 28-30 in Columbus, Ohio. Go to https://ohiolinux.org/ for more information.


My web site is at hhttp://www.ahuka.com/.


Remember to support free software!