Important:

Cleaned up and exported spreadsheets are in "Madidi.cleaned_up.zip" and *.xls.

Exported file names may not contain spaces.

Before exporting a spreadsheet tab to CSV, delete the 2nd header row.

    Otherwise, it will be interpreted as a data row.

Remember to export both plots and organisms tabs (see translations below).

Translations:

Inventory description, Datos descripcion de las PPM = plots

Data base, Datos de  las PPM = organisms

PPM, PP = Parcelas Permanentes de Muestreo = BIEN2.datasources.xlsx "Madidi Permanent Plots"

PT = BIEN2.datasources.xlsx "Madidi Transects"

Notes:

Expedition number and Expedition name are consistent (globally unique) between PPM and PT data

There appears to be no data of inventory type C, although it's listed in the column name "Type Inventory (C, PP, TP)"

Questions:

How should an "expedition" (trip) be mapped: project, plot, plot event, or something else?

    See note above about Expedition name/number

How should an "inventory" be mapped: plot or plot event?

Why is inventory type only in the organisms sheet, but important enough to be included in the flat file name?

To do:

Need a SQL function to translate Spanish dates to English

    can Python strptime(), Python dateutil.parser.parse(), or PHP/GNU strtotime() do this?