This is an experimental tool for a very specific purpose - creating diplomas for scout volounteers and leaders showing long term comittments in scouting.
These diplomas can be used outside scouting, they are however tailored for situations where you want to express gratitude and recognition for continous work.
How it works
You will need to OpenOffice.org files:
- one diploma template in OpenOffice.org 2.0 text file format
- one name-and-semester spreadsheet in OpenOffice.org 2.0 spreadsheet format
File Format and data layout
The idéa behind the diplomas is that (at least in Sweden) five years of continous active committment to the movment yields a honourary badge. Since each year has two semesters, five years equals ten rows on the diploma. One full diploma = one honourary badge. Easy.
Important: the diplomas processed by this tool are multi-line diplomas - see the examples. The diploma template needs to have one table with one single cell (at least) and the table MUST have the name name. Furter, the diploma demplate need another table with 11 rows and at least three columns and that table MUST have the name years.
The Spreadsheet is conceptually a database. This tool assumes one sheet per person, and each sheet must have the name of the person in cell B1. Further, the ten rows are rows 3 through 12 and columns are:
- A - Semester
- B - Position, like leader or vice chairman
- C - Name of chairman or whoever certifies this row
- Example (Swedish) of diploma template
- Example (Swedish) of spreadsheet with leader names and positions, one person per sheet
Use the form below. Select your files, upload it using the create button and enjoy the almost instant result.