Your server is running PHP version 5.3.29 but this plugin requires at least PHP 5.4. Please run an upgrade.

Plant’net Introduction | Michael Spratt

Plant’net Introduction

Plant’net Introduction


This is the landing page of the Plantenette Excel Documentation.

Scroll down through the different tabs and associated links.

See also  Project Overview, Downloads, video presentation and Links



Simulating Phenological Fitness or Plant Survival Probability due to climate change depends upon daily weather data (ie. Centre Européen de Recherche et de Formation Avancée en Calcul Scientifique (CERFACS),)  for a given latitude and longitude.

For a given latitude and longitude there are 10 weather measurements(ie. min, max temperature, wind, precipitation, pressure, solar radiation, etc), for every day (365 days/year), for nearly 10,000 Latitude, Longitude combination.  Over 5,3  millions records

Other elements include :

Geological characteristics (slope, soil type/condition, infiltration considerations, etc.)

“User Selected” plants (indigenous, invasive, decorative, nutritional, etc.) all their parameters and

“User Selected Species Models” each plants has at least seven models for leaves, flower, fruit, seed, fire, drought, each model has several options.

Approx 75 data elements describing a plant’s reaction to climate, fires, frost, drought, etc.,

Roots and vegetation are classified into 3 straits each and adjusted to the latitude and longitude.

The species that produce the most viable flowers, fruits and seeds have better chances for survival.

The goal is to compare several species competing against each other for water, sunlight and root space over a long term (100+ year period).


Simulation Excel

The objective this phase is to create a simulation with its data, models and calculations in Excel.

There are several reasons for decomposing this simulation and scaling it down to an Excel version.

  1. Excel is pedagogic,  easier to understand, evolve, enhanced and adapted
  2. Excel is flexible, easier to re- structure for user control and data manipulation
  3. Excel has tools for outputs, graphics and documentation
  4. Excel has unexplored potential as more people can understand  Phenological fitness data and calculations
  5. Excel has greater calculation potential.

There are several major obstacles on the road to an Open Science application.  Using an object approach and Excel’s advanced features we can make considerable progress toward open and active community.

Excel techniques :

1 “black-box” or “function” approach –combining “Calculating building blocks”

  1. Each sheet (black-box) has input, outputs, local control and a buffer zone.

3 “Redirect” technique. Dynamically create pointers to different  data sets (ie. years 1, 2, 3. etc.) using an incremental counter

4 “Table lookup indexes” An index obtained from incremental counters, location or variable

5 “Retain-if” saves data (ie to a line) only when conditions (line number = year number) are met.

6 “Macro” used to increment a counter, in our case the year and species index, but also latitude and longitude.

7 “Color & comments” – ease of use and in-line documentation



A Site is a unique combination of Latitude and Longitude.

There are currently 9,989 Sites, with one or two other data elements.

The Site file is a GIS (ie. Open Street Map, Google map, etc.) which stores geological data like slope and water holding plus urban data, maps, satellite images, etc.

Discussions, consultations and effort are required to obtain a data Site file.

Latitude and Longitude. are the site’s location while Latitude and Longitude, Year and Day are the keys to the Daily Weather file.


Weather (Daily Weather Details)

Each Site (Latitude and Longitude), has a Meteorological (weather) Station.

Each day the station records the :

Day of Year _ day_no

  1. Relative humidity at 2 m  (Humidité relative à 2 m) [RH, %]
  2. Medium surface pressure (Pression moyenne au surface) [Press kPa]
  3. Daily precipitation (snow and rain) (Précipitation quotidienne (neige et pluie)) [P, mm]
  4. Daily sum of visible radiation (Somme quotidienne de rayonnement visible) [GLO, MJ/m²]
  5. Daily amount of infrared radiation (Somme quotidienne de rayonnement infra rouge [RAT, MJ/ m²]
  6.  Average specific humidity (Humidité spécifique moyenne) [Q, kg/kg]
  7. Daily minimum temperature at 2 m (Température minimalle quotidienne à 2 m) [TI, ° C]
  8. Average daily temperature at 2 m (Température moyenne quotidienne à 2 m) [T_a, °C]
  9. Daily maximum temperature at 2 m (Température maximalle quotidienne à 2 m) [T_i, °C]
  10. Average wind speed at 10m hight (Vitesse moyenne de vent à 10 m) [Vu, m/s]


There are 9,989 Sites with the 10 daily weather elements from 1951 to 2098 or approximately 55 million unique data elements.

Plus there are many other data elements which can be calculated based upon the Latitude / Longitude and the Daily Weather

Solar Declination – DEC, Day Length, Hours of light, etc

Daily Weather[/button

The file contains




Plant Species  (for more go to Plant Species Details)

Species data concerns its Provenance and reaction to Frost, Drought and Fires

Variables which on-line community member can note :

Member Input Calculations :
Leafing Date (Leaf Unfolding Date) – Dl

Flowering Date – Df

Ripening Date – Dr

Leaf Colouring Date – Dc

Dormancy Entrance (of the buds)

Hydric stress on fruit ripening

Leaves Surviving Frost – Il

Photosynthetic Index Depending on Temperature.

Frost injury of Leaves Index –  Il

Thermal Energy Available Since Flowering – Er

Frost Injury of Flowers Index – If

Fruit Ripening Index – Ir

Probability of Frost Survival – Sf

Probability of Drought Survival – St

Probability Fruits Reach Full Ripening (cumulated probability of the Gaussian distribution (Ec, sm))

Fitted Parameter of the Ripening Date Model – Etc



Plant Species Details

Plant Species data and calculations vary depending upon the plant but all Species data is placed in the “Species” sheet.



Models   (for Models Details)

Models and their initial values are assigned to a Species.  Models calculate Site, Species and Climate

Models Evapor-Transportation Senescence


Leaf Habitat Fruit Maturation Drought




Control  ( for Control Details)

User options and Initial values are grouped into a Control sheet.

Some user options are

Beginning Year    2010 Ending Year    2019

The 3 Species to calculate Species No.    Select Species No    Current Species 1                                   6                        Quercus_ilex_??? 2                                  7                         Quercus_ilex_7 3

Many other variables are also stored here :

Maximum Soil Depth

Soil Water Capacity

Air Psi for Saxton’s equation



Work Area  (Work Area Details)

This area groups all the initial values for the Species and Control variables and stores the results for each month or year.

The objective is to group, into one sheet all the initial and annual results.  As the year counter augments, the year number Daily-W


Work Area



Calculations (Calculations Details)

Model calculation sheets like Sierra, Phenology, Evapotranspiration, etc. acquire their input data from the “Work” sheet, which collates the “Species”, “Daily Wheather_9999” (9999 is the year) and “Control” sheets.

This data is volatile as it updates every time the species changes (new model numbers and data). Plus the columns and their data are subject to changes. In order to protect sheets from species dynamics a “buffer area” (in yellow). Buffers take data from the “Work area”, in their sheet, in this case Frost. This makes it easier to cut and paste sheets as only the buffer area and calculations need to be copied and not the dynamic Species or “Work” data.

Site data is stored in variable such as :

Daily Mean Temperature – Ta

Daily Minimum Temperature – Ti

Monthly Precipitations – Pm

Total Holding Water Capacity (in mm) – Wh

Monthly Ground Water (in mm) – Wm

Monthly potential evapotranspiration – Em

Monthly actual evapotranspiration – Am

Monthly Index of Moisture – Ia

Soil Moisture – Sm




As you can imagine there are several problems associated with taking this project to the next level




Here are some site which maybe interested. Links





Under Construction