Data Entry & Excel Project (This is a Real Job, Not Scam)
$30-250 USD
In Progress
Posted over 11 years ago
$30-250 USD
Paid on delivery
I accidentally put inthe wrong price range for my previous project. This one has the coorect range. Please read this description FULLY!
I have 77 MS Word files (One for each County of Oklahoma) that list all the plants in that county. I need someone to take these files and sift through to compile a single list (without any repeats) of all the plants in the State of Oklahoma. I need the information put into an Excel worksheet with a column for each of the following:
1. Family
2. Genus
3. Species
4. Subspecies
5. Variety
6. Common Name
You will ignore the "species count." I don't want it in the excel sheet. However, ALL entries that have anything different in them MUST be kept. (So, "Acer Negundo Boxelder" is not the same as "Acer Negundo Negundo Boxelder." BOTH should be kept).
The list will need to be alphabetical and have a number column to the extreme left. Each entry will also need to be cross-referenceable to a separate list of what counties it is found in. I don't need a list of plants in each county. I already have that. I need a list of what counties each plant is found in. I would like to 'click' (i.e. hyperlink) on an entry and be taken to a list of the counties it is found in.
If you do not understand how to do this last (i.e. crossreferencing each entry to a list of the counties it is found in) DO NOT APPLY. This is the MOST important part. I will pay $50 for this project and any bids above or below will be ignored. Please use the key word 'Flora' as the first word in your bid so that I know that you read and understand what I need.
I have attached an example file of 2 of the 77 counties.