Create Spreadsheets of the Best/Top External Solid State Drives (SSDs)
Budget: $10 – $15 USD
The 2 attached spreadsheets have data taken from 2 websites: the 2 rows in Spreadsheet SITES. The SSDs spreadsheet contains the SSDs listed in the 2 websites having 2TB or more. Your task it to find 25 additional websites that list the best/top Solid State Drives (SSD), click any links in the lists that describe the SSDs, and add the website and its list of SSDs to the 2 spreadsheets with the following columns:
SITES spreadsheet
A. Sequential Number
B. URL of result
C. Initials of the page title
D. Page title
E onward: For each entry in the list in the site page, if it is an SSD with 2TB or more, add it to the SSDs spreadsheet (if it is not already there) and its number in column A of the SSDs spreadsheet to the SITES spreadsheet column representing its number in the list, where entry 1 is in column E. For example, the 1st entry in the list of best SSDs would be in column E, the 2nd in F etc. For entries that are not an SSD with 2TB or more enter "x" in that column.
SSDs spreadsheet
A. Sequential number
B. Manufacturer of SSD
C. Name of SSD
D. Capacity in TB (2 or more) with additional rows if more than one capacity
E. Minimum price seen for it
F. Maximum price seen for it
G Onward: For each list of SSDs that the SSD appears in, a Rank-Site column has the SITE number from column A of the SITE spreadsheet, dash, the SSD's entry number in the list, period, site Title Initials. For example, the Crucial x8 SSD has 2-1.TBESF2 in column G because site 1 (pcmag.com) with Title Initials TBESF2 has an SSD list with entry number (Rank) of 2 being the Crucial x8 with 2TB and a price of $197.99 (SSD columns D, E and F.) The prices can change if other lists contain the Crucial X8 with prices more or less that $197.99 so the minimum and maximum prices seen will change.
SITES spreadsheet
A. Sequential Number
B. URL of result
C. Initials of the page title
D. Page title
E onward: For each entry in the list in the site page, if it is an SSD with 2TB or more, add it to the SSDs spreadsheet (if it is not already there) and its number in column A of the SSDs spreadsheet to the SITES spreadsheet column representing its number in the list, where entry 1 is in column E. For example, the 1st entry in the list of best SSDs would be in column E, the 2nd in F etc. For entries that are not an SSD with 2TB or more enter "x" in that column.
SSDs spreadsheet
A. Sequential number
B. Manufacturer of SSD
C. Name of SSD
D. Capacity in TB (2 or more) with additional rows if more than one capacity
E. Minimum price seen for it
F. Maximum price seen for it
G Onward: For each list of SSDs that the SSD appears in, a Rank-Site column has the SITE number from column A of the SITE spreadsheet, dash, the SSD's entry number in the list, period, site Title Initials. For example, the Crucial x8 SSD has 2-1.TBESF2 in column G because site 1 (pcmag.com) with Title Initials TBESF2 has an SSD list with entry number (Rank) of 2 being the Crucial x8 with 2TB and a price of $197.99 (SSD columns D, E and F.) The prices can change if other lists contain the Crucial X8 with prices more or less that $197.99 so the minimum and maximum prices seen will change.