Home Raumfahrt Launch log Site Map counter

Launch log Converter Tutorial 5

This little tutorial should show you the capabilities of the program, especially the possibility to create web pages. In this chapter I want you to show the date and field summary function and the chart functions.

The Date and Field summary function combines the field and date summary function. It is best explained in an example. Select the "Ariane" as an Launch vehicle. And then go to the Summary Menu and chose "Summary by date and field". The Launch vehicle as field should be preselected. Now type in the "Group by ... chars" the phrase "Ariane 4" like in this dialog. Please uncheck the "No success row", which will appear in the field and date selection dialog (and not on the field selection dialog). (When you have checked Check box "Group by first word" you first have to uncheck it to enable this edit field.

You will get an Table like this:

Launches by Model

Launch Vehicle 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Launch success [%]
Ariane 1 Launches 1 1 2 1 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81,82
Ariane 2 Launches 0 0 0 0 0 0 0 1 1 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83,33
Ariane 3 Launches 0 0 0 0 0 2 3 1 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90,91
Ariane 4 Launches 0 0 0 0 0 0 0 0 0 2 4 6 8 7 7 8 11 10 11 10 9 8 6 8 1 0 0 0 0 0 97,41
Ariane 5 Launches 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 4 2 4 3 3 5 5 6 2 89,47
Summary 182 171 93,96

This is a Table, where the launches are first grouped by the Model (the phrase has a length of 8 chars, meaning that the first number after "Ariane" is used to group, but not the following numbers or chars.  At second you get for every year a column with the number of launches of this model in this year.

You can see that the Ariane 2 had her first launch in 1986 - after the Ariane 3, which started in 1984 - and the last launch was in 1989.

When you uncheck the "No success row" you will get a second row for every launch: This time only with the successful launches in this year:

Launches by Model

Launch Vehicle 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Launch success [%]
Ariane 1 Launches 1 1 2 1 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81,82
Ariane 1 Success 1 0 2 0 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 / 11
Ariane 2 Launches 0 0 0 0 0 0 0 1 1 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83,33
Ariane 2 Success 0 0 0 0 0 0 0 0 1 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 / 6
Ariane 3 Launches 0 0 0 0 0 2 3 1 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90,91
Ariane 3 Success 0 0 0 0 0 2 2 1 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 / 11
Ariane 4 Launches 0 0 0 0 0 0 0 0 0 2 4 6 8 7 7 8 11 10 11 10 9 8 6 8 1 0 0 0 0 0 97,41
Ariane 4 Success 0 0 0 0 0 0 0 0 0 2 4 5 8 7 7 6 11 10 11 10 9 8 6 8 1 0 0 0 0 0 113 / 116
Ariane 5 Launches 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 4 2 4 3 3 5 5 6 2 89,47
Ariane 5 Success 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 4 1 3 3 3 5 5 6 2 34 / 38
Summary 182 171 93,96

You also see that the html table, and the CSV Table alone is not useful. its better to use the data to create a chart. That leads us to the last part: Charts. I first created the CSV export function to create charts with Excel.

For each summary function there is a corresponding chart. For example you can create from the data above this chart:

You easily can see how the models were used over the years.

In the chart Menu you will find a Menu point for every summary function. When you right click on the chart, you can set some options. For Bar Diagrams you can set the color of the first and the second series of bars. you can change the dimension of the chart and print or change the 3D look.

For many summary functions there are different type of charts available. Perhaps you try them to look how good or bad they fit to the data.

Two new charts are available which do not correspondent with any summary function. The success chart shows you the summarized success percentage of a launcher of the years. For example this is the success of the Ariane from 1979 up to 2008:

When you answer the Question about a summary over the years with yes, you get the Area chart in the background too:

Success Chart

The second new chart is the trend chart: It summaries to launches and the successful launches in the background and you also can show the number of launches per year: You see in all 3 Charts of this page the same data, showed under different aspects. You can include a chart in an html page when you check "Include charts in HTML". An PNG Chart with the same name as the html file will created and stored in the image folder you specified in the folders... settings.

Trend Chart

Complete in HTML

This option is used from the author for his launch lists. It groups the data after a field you say and generate separate tables for each group. foe example you can group the Ariane 5 launches after 8 chars and will get separate lists of launches for the Ariane 5G, G+, GS, ES and ECA. After these block of lists of every launch you will get the 3 summary data in html:

And the correspondended charts and also the Trend and success chart. all in one HTML chart and 5 graphics, numbered at the last position. Examples of generated HTML pages you find in my launch list section of my homepage.


© of the Text: Bernd Leitenberger.
Sitemap Kontakt Neues Hier werben Bücher vom Autor Top 99