Open
Office Calc - free open source spreadsheet at least as good as Excel
and Quattro Pro. Open Office is from Sun Microsystems and has been
developed over two decades. It is just as good as Windows Office and is
in some ways superior in our opinion. Goto http://www.openoffice.org and
download the best version or your computer. Then import in the XLS
Spreadsheet version of Paul from the link above in 2. Open Office Calc
is a Microsoft Excel clone and much more! 
| COROLLA COLOR: | |||
| The
basic formula is: [color][shade or intensity] such as pink light, For example: pink dark (coral) blue medium red dark (blackish) |
|||
|
If the flower has multiple colors we use the format: [color][shade or intensity][pattern type][secondary color] such as: |
|||
| Blue medium margined white | |||
| White thumbprint pink | |||
| White tinged yellow | |||
| Pink medium centered violet | |||
| Pink bar white (aka a pink flower with white chimera pinwheel) | |||
| Violet fantasy pink (violet with pink speckled) | |||
| Pink
light margined white fantasy violet = pale pink base with a white
edge with violet specklings |
|||
|
The pattern types include: |
|||
|
Margined – thin to wide picotee or edge of contrasting color. A fine
contrasting picotee is often called a Geneva edge. |
|||
| Tinged
– a general flush or glow, not in a particular pattern or place,
generally, an overall hue or glow |
|||
|
Centered – eye or center of another color or tints mostly confined to
the corolla's center |
|||
| Thumbprint
– a distinct spot or central color zone in the middle of the
petal as if stamped by a finger. But where does a big print end and a white margin on blue or pink begin? |
|||
| Bar
– what the AV calls “Chimera” or pinwheel stripes, the secondary is
the color of this central band or zone. In truth, fantasy type |
|||
| And
all variegated leaf clones are chimeras too. By some odd twist of
fate “chimera” in AV circles means just one type of chimera |
|||
| Fantasy
– having a very fine mottling, streaking, or speckling of a
contrasting color, these spots most 1-2mm wide if not smaller |
|||
| Mottled
– having a larger mottling, large spots, or bit sectors of a
contrasting color, those spots mostly 3-10mm wide, sometimes in sectors
or wedges Why use phrases like "red dark" instead of "dark red"? Good question. This way when you sort by the corolla color field, all the reds, pinks, blues, etc. are grouped together. Dark red would group with dark pink and dark green - which is a missed opportunity for grouping cultivars. In Google Fusion Table you can also specify "corolla color starts with...." a color term and this lets us list all the blues, reds, pinks, etc. regardless of intensity, patterns, etc. Google Fusion Search Ideas: 1. Use the "contains" option when searching on corolla color. You could say "contains green margined" and list all the green-edged cultivars regardless of base color. This list would pull white margined green, pink dark margined green, blue light fantasy violet margined green, etc. 2.Want a list of all fantasy clones or chimera (bar, stripped) clones, again use the "contains" option for the terms "fantasy" and "bar". You'll get white fantasy violet along with violet fantasy pink. Color terms omitted and their equivalents: "purple" - we use violet such as violet light, violet medium, violet dark. There is technically much difference between purple and violet (the later being a more pinkish or coral-toned shade). In truth, most "purple violets" have strong violet tones, so the two terms are merged as separate is nearly a hopeless exercise. "fuchsia" - fuchsia is different things to different people. The British have a different standard than Americans. In general, we use "pink dark (magenta)" or "pink dark (coral)", the later less harsh and with fewer blue tints for what is called fuchsia. Some people consider mauve and fuchsia to be the same color and that is another issue with trade terms. The "violet-red" color of this database is also part of what some people think of the term fuchsia. "cream" - white is used since most white flowers in any plant have cream tones are first or later when fading. A yellowish-cream flower here is "white tinged yellow" "gold" - we are using yellow light, yellow medium, yellow dark, etc. "red" - wow, where do we begin? Everyone wants to offer a true red violet but many are not. The codes red light, red medium (rose-red), and red dark (cranberry) are used for true reds. Violet-red reflects a more grapey or intense rosy-red shade of things. "burgundy" - this should ideally have some relation to the wine of this name. People use burgundy for what are called here red dark, violet-red dark, and violet dark. |
|||
COROLLA TYPE |
|||
|
Single - most flowers have 5 basic petals, mostly in a flat face, if
cupped, not strongly so. |
|||
|
Single Bell – campanulate or bell-shaped corolla to various degrees,
generally not flat but petals forward-pointing |
|||
| Single
Starfish – a rare mutation with single petals folded or fluted
to be narrow like arms of the starfish. We should be getting more of
these in future years |
|||
|
Semi-double - having 6 or more petals and petaloids (minor, reduced
petals), the center often clustered with many tiny petaloides. |
|||
|
Double - having 10 or more petals, usually these of nearly equal size,
overlaps with "semi-double" and many plants have both types. If the
cultivar often attains the true double morphology, we will pick this
term for it. |
|||
| Single Wasp – very irregular, asymmetrical flowers, somewhat insect-like as the name implies, often some petals much larger than others. Some extreme types have a very narrow oblong petal with a distinct narrow base or claw at the petal attachment point, petals not generally wide, often narrow, the upper petals sometimes reduced to tiny segments a fraction of the size of the three lower petals (10-40% of their surface) | |||
| COROLLA MARGIN: this field descriptions the margin
of the petal |
|||
|
Flat – mostly flat, sometimes faintly convex or concave, very much a
flat face or species-type petal formation |
|||
|
Semi-undulate – weak to low waves to the petals |
|||
|
Undulate – medium to strong waves to each petal, not finely crisped or
crimped |
|||
| Crisped – very finely toothed, lacy, crested, or sharply toothed edges. Many of the green-edged clones are crisped. Some have distinctly folded and fluted edges which are noted in the Misc. field. Others are more fimbriated (finely incised, lacy) while others are more serrulate (finely toothed) on close inspection. | |||
| LEAF
GROUP: We are trying to restore classic terminology here and not using
the amateurish, even if traditional terms of AV societies.
Professionalism matters. |
|||
| Green
ovate – this is most cultivars, a basic ovate to cordiform
(heart-shaped) leaf. For some unknown reason the term “ovate” in some
AV
circles has come to refer to a cupped, concave leaf. |
|||
|
Green undulate – a wavy or ruffled leaf, sometimes called a Longifolia
leaf in society circles even if not long!!! A variegated undulate leaf
is coded by color (ie. white-margined, gold-mottled) and the margin
notes in the Misc. field instread. Green clacamas - leaves mostly narrowly ovate to elliptic, notably with 5-7 parallel or closely spaced reddish or bright pink veins on the leaf reverse, contrasting with the silvery to silvery-green base color. In some clones there is paler striations or veins above too in a so-called watermelon-like pattern; this being a very imprecise and ill-defined term. Veins can be arcuate or incurved as Dogwood (Cornus) in some cases. |
|||
| Green
elliptic – much narrower or longer-looking blade, similar to some
Longifolia references but without the waves or undulation. This
taxonomically accurate term “elliptic” is more accurate |
|||
| White-margined
– this is the classic white-edged or Tommy Lou leaf,
which in horticultural terms is a “margino-maculata” type of the
variegation, a chimeral margin formed of fused spots. Very few cultivars have a classsic margination in the style of other variegated plants |
|||
| White-margined
thin – a recent code for some clones with faint, weak,
often slightly spotted white margins, usually 2-7% of surface White-margined clacamas - white edge or stripes plus the clacamas type blade. This code added in version 1.2 white-margined undulate - white to cream leaf edges with a distinctly wavy or undulate blade. This character state was added with Version 1.2. |
|||
|
Pink-margined – as white-margined but the youngest leaves are some
shade of light, medium, or tannish-pink PInk-margined thin - very thin pinkish leaf edge, often ony the teeth or some narrow portions in rose, creamy--pink, or tawny-rose. Pink-margined undulate - blush to rich pink leaf margins but on a wave or undulate blade edge. This character state was added with Version 1.2 |
|||
| Tan
crown- new growth from tan to olive-buff to golden-green shades,
usually with leaves maturing to dark greens, these have subtle
suffusions and are maculated or margined in the true sense |
|||
| Green
Concave – green leaf with rim turming up to form a cup. Some
(not all) “spoon” leaf cultivars have this upwardly cupped style |
|||
| White-mottled
– leaf is spotted white over most of the surface, not
confined in general to marginal spots. These are called in most AV
circles a “mosaic”, a horrible word implying a mosaic virus infection. |
|||
|
Gold-mottled - similar to the above but markings in
in yellow, gold, tan, or beige tones. "Mosaic" in AV literature. |
|||
| Pink-mottled – as white-mottled but light pink to medium pink markings, often a silvery-rose shade. | |||
| MISC – general comments on the cultivar, including unique traits, clarifications of other fields, etc. | |||
| HABIT – or plant size and growth form | |||
| Standard
– a full-sized modern violet |
|||
| Semi =
semiminature – usually 4-6 inches wide |
|||
| Mini =
miniature – usually 2-4 inches wide |
|||
| Trailer
= trailing or cascading habit. We do not distinguish between standard,
semi, and mini trailers here as those classifications are hard to make at times and most trailers are in general quite small. |
|||
| ORIGIN – originator name | |||
| Format is: | |||
| [last name][initials if needed] | |||
| Doe J | |||
| Metropolis Nursery/Smith | |||
| Other, non-named origins are: | |||
| Species = a true Saintpaulia species, subspecies, variety, botanical form, or direct clone from them | |||
| Unknown | |||
| [country] = sometimes a country is known but not the name of the originator | |||
| COLLECTION – this field is intended to record your collection data or plant accessions | |||
| One suggested format is: | |||
| [nursery source][year][price paid if known][plant type] | |||
| For example: | |||
| Lyon 2003 $3.50 leaf | |||
| Violet Barn 2009 $6.00 plant | |||
| Lost or removed plants may be coded with a * at the beginning so they sort out in a separate set | |||
| For example: | |||
| *Home Depot 2008 $2.99 plant | |||
| A second format using collection numbers based on the first format -if the collection # is first, you can sort by it in numerical order | |||
| 2001-012 Violet Gallery $4.50 plant | |||
| 2001-013 John Doe trade leaf | |||
| CULTIVAR FINDER LINKS: Beginning in version 1.2 we are filling up the Collection field with live, internet source links to major vendors. We
are beginning with established, reliable vendors like Lyndon Lyon,
Violet Barn, Blue Bird, Karen Dean, Violet Gallery, and several others
we can personally recommend. |
2001-014 Mary Smith trade plant |
||
| TRADE/SALE/WANT – this field allows you to sort and compile lists – extracting them with a copy-and-paste to another file | |||
| For example: | |||
| Trade (leaf) | |||
| Trade (plant) | |||
| Sale (leaf) $1.99 | |||
| Sale (plant) $5.99 | |||
| Sale (plant) bid | |||
| Want | |||
| You can easily produce trade, want, and sales list by sorting on this field. Be certain to select the entire database before sorting. | |||
| VERSION – this identifies under which version each cultivar (or amended record thereof) was issued. | |||
| Why is this important? “Variable upward compatability” to be clear. Or not. This means if you are using 1.0 and new versions are available you | |||
| Simply download the new file and sort by version number. Then copy and paste records in versions 1.1 and 1.2. If you | |||
| Are already using 1.1 you instead just add cultivars from version 1.2, and so on. This system of version allows users of many | |||
| Different versions, old and new, can get just what they need to add – no more, no less. Having years of plant database | |||
| Experience, your author has proven this kind of system works well for everyone. | |||
