History: SPID Notes on the columns used in the spreadsheet

Source of version: 3 (current)

::''This page gives tips that will help you understand the structure of the flashcards' source website; it will only be useful if you are considering major changes to the flashcards' design.''::
!Notes on the columns used in the source spreadsheet for the fish Species ID Anki flashcards
*The 'Tags' column (the right-most column) is generated from column D only because it is easier to see on the LHS of the spreadsheet. Tags are not a specified field. The way that Anki works is that if you have one extra column after all the columns that match the fields you have told Anki about, then Anki treats that extra column as a Tab. Hey, it works. 
*The 'Source ID' field: 'Source ID' values are based on the Barefoot Conservationist .pdf files I was given - the 'B' series numbers each photo in the 2016 BC Butterfly .pdf, 'H' series: Herbivores & Omnivores, 'C': the Carnivores, 'P': Pelagic, 'S': Sub Strata; the '~' series records these Comments. Binomial Genus-Species names uniquely identifies every species known (except for 5 species that have common binomial names across different Kingdoms); for records that are not uniquely identified by being a species, the Source ID provides a unique identifier. 
*The 'Record ID' field: I originally used the 'Source ID' values to create a unique sorted identifier for each record in the Anki program, but Anki seemed to be doing weird things with the sort order, sorting on only the numbers within an alphanumeric field??! So I figured 'serve me right' for attempting to use meaningful data as a record identifier, and created a separate integer 'Record ID' field for Anki to sort on. I have high-numbered the Comments (I do not want to scare a new user with a Comment posing as a flashcard), but not so high that Anki is tempted to create a massively sparse database; I have left the comment rows at the start of the spreadsheet, but I import them from a separate temporary .txt file after I have imported all the taxa (e.g. species) rows. If you leave the values in 'Record ID' unchanged, and if you do not change/delete/add to any of the Anki Fields, then a user can top-up their deck with new publicly available photos and/or entire new rows.
*The 'Species' field: <br>Leave this field blank if not known - do not enter 'sp.' or 'spp.' etc, otherwise links to web pages will fail. 
*The 'Show...' fields: <br>Anki has only primitive 'IF' commands that create a card / show a group of fields or an alternative depending on whether various fields are non-blank or empty. I have avoided indicating non-blank with a 'Y', because the usual opposite of 'Y' is 'N' (and 'N' is non-blank which thus has the same effect as 'Y'); instead I have used 'X' for non-blanks. Because I have not been able to confirm that the photos that BC provided have appropriate permissions, I left the 'Show these pic 1s' field blank. I use a further IF command for the 'Show these pic 2s' column so as to not attempt a Wikipedia lookup for if the exact species is not known.
To understand further details, you could perhaps view Excel or Calc documentation on IF and ISBLANK functions. You may also prefer to understand the difference between Absolute and Relative addressing to understand why some cells are addressed as (e.g.) A1, $A1, A$1, or $A$1.
Projects
You forgot your Google ad_client number !
History: SPID Notes on the columns used in the spreadsheet

Source of version: 3 (current)

Last-Visited Pages
