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

42 - LibreOffice Calc - Data Manipulation 2: Standard and Advanced Filters - Ahuka | 2014-11-21

You can set a Standard Filter from within the AutoFilter drop-down, or you can go there through the Data menu by selecting Data>Filter>Standard Filter. Now lets look at the question we ended the last tutorial with: How many females over the age 40 had a case in 1978. We saw we could get this by manually putting checkmarks in every age that was greater than 40 using AutoFilter, but how do we do this using Standard Filter? - For more go to http://www.ahuka.com/?page_id=897


41 - LibreOffice Calc - Data Manipulation 1: Sorting and AutoFilter - Ahuka | 2014-11-07

The next major area of investigation for this series is how we can do data manipulation in Calc. Although Calc is not a database, it can be used for some data analysis and manipulation. When I worked for the finance department of a hospital, it was very common for the financial analysts to get a data dump from a centralized system as a CSV file, load it up in a spreadsheet, and then slice-and-dice the data to get the answers they wanted. It is not anywhere near what you can do with a good relational database and a structured query, but you can do some quick-and-dirty analysis here. - For more go to http://www.ahuka.com/?page_id=879


40 - LibreOffice Calc - Other Functions - Ahuka | 2014-10-24

We spent a lot of time looking at some Financial and Statistical functions. I dont propose to go into the remaining types of function in nearly the same depth. That would draw out the series without benefit to most people. But I do want to highlight some of the functions in the other categories so that you have an idea of what is possible in Calc. Remember that if you need to know more about them Google is your friend. - For more go to http://www.ahuka.com/?page_id=875


39 - LibreOffice Calc - Inferential Statistics Functions - Ahuka | 2014-10-10

Inferential statistics is what you do to say that something is likely, or that it is not due to chance, or things of the sort. It goes beyond simply describing what is in the numbers and lets you say something about what the numbers in a sample might mean for the population that generated the sample. There are several type of Inferential Statistics that I want to address in this tutorial, beginning with the idea of a confidence interval. - For more go to http://www.ahuka.com/?page_id=861


38 - LibreOffice Calc - simple Descriptive Statistics - Ahuka | 2014-09-26

In Statistics there are generally speaking two types of analysis, broken down between Descriptive and Inferential statistics. The difference has to do what what claims you are making about the data. If you are simply stating something about the data (e.g. there were more men than women in the sample) that is descriptive. But if you make a claim that something is not likely to occur by chance, for instance, or that something is statistically significant (and both of those statements are essentially the same thing) then you are in the realm of inferential statistics. Calc has functions to do both kinds of analysis, and this tutorial will examine some of the common descriptive statistics in Calc and how they are used. - For more go to http://www.ahuka.com/?page_id=844


37 - LibreOffice Calc - More Financial Functions - Ahuka | 2014-09-12

We take a look at a number of related financial functions in this episode, and discover that they are strongly related by using the same variables over and over. We construct a Mortgage Repayment Schedule, and look again at the principles of good spreadsheet construction.


36 - LibreOffice Calc - Financial Functions - Loan Payments - Ahuka | 2014-08-29

In this episode we discuss the function for determining the loan payments on a car loan, compare a manual calculation with the use of the PMT function, and derive some useful lessons.

Links:


35 - LibreOffice Calc - Introduction to Functions - Ahuka | 2014-08-15

In this episode we review what a function is, discuss the different types of functions available in LibreOffice, discuss the concept of arguments in mathematics, and present a general process for using functions in Calc.

Links:


34 - LibreOffice Calc - More on Chart Editing - Ahuka | 2014-08-01

In this episode we review the options for editing your chart, do a brief recap of the object model, and create an example of a chart with a secondary Y-axis.

Links:


33 - LibreOffice Calc - Creating Charts - Ahuka | 2014-07-18

In creating a chart or graph you have a number of options that can make your chart easier to read and understand. In this episode we look at these options and explain what each of them does.


32 - LibreOffice Calc - Introduction to Charts and Graphs - Ahuka | 2014-07-04

There are many Charts and Graphs available in LibreOffice Calc, but choosing the right one makes a difference. In this episode we review your options and help you to make the right choice.


31 - LibreOffice Calc - Sheet Editing and Navigation - Ahuka | 2014-06-20

This episode covers various editing techniques you might use, including multiple sheets, and adding, removing and hiding rows and columns. We also discuss how to navigate around a multiple sheet spreadsheet.

LibreOffice Calc, like all spreadsheets, contains a large number of cells in various rows, columns, and sheets, and navigating that can get a little tricky. As we saw previously, each cell has an address, which is marked by the column (letters) and the row (numbers), always in that order. But in fact the address can be larger because we never discussed sheets.

By default, when you create a new Calc spreadsheet you will have three sheets in it, which you see as tabs along the bottom of the screen. They will be called Sheet 1, Sheet 2, and Sheet 3 at this point. But these defaults can be changed by going to Tools–>Options–>LibreOffice Calc–>Defaults. On this screen you can decide how many sheets you want to have on a new document. While the default as it comes is three (similar to Microsoft Excel) you can change it. On my copy of Calc I changed it to 1, because most of the time I never need more than one sheet for my work. I can also change the default naming of new sheets here. Instead of each sheet being “Sheet 1″, Sheet 2″, etc. I could make it something else, like “Tab 1″, “Tab 2″. and so on. I never bother with this though, because I will always name my sheets for what they are doing in a given spreadsheet (e.g. look at what I did when I created the simple model for “What-If” analysis.) And if I need to add a sheet, I can just go to Insert–>Sheet to bring up a window to specify where the sheet should go, what it should be named, or even insert a sheet from a file . A CSV file would be a very good choice here, such as if you wanted to bring in data from a database or another spreadsheet for use in the current spreadsheet.


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

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


Ahuka 20 LibreOffice Writer FramesIntroduction and the Type Tab - Ahuka | 2014-01-17

This episode introduces the discussion of Frames in LibreOffice Writer by opening the Properties window and looking at the first tab, Type. Because there is so much to discuss about this tab, it is the only one we will look at in this episode. In the next episode we will wrap up the discussion of Frame properties by looking at the other tabs in this window

Links

The written version of this tutorial can be found on my Web site at http://www.ahuka.com/?page_id=476


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!