search

Akaitatsu / modsnacks

MIT License
0 stars 0 forks source link

Automate Duplicate Check #11

Closed Akaitatsu closed 3 years ago

Akaitatsu commented 4 years ago

Desired behavior/state Create a script that analyzes the TellMe block stats file to detect duplicates.

Actual behavior/state Tell Me block stats file is currently imported into Excel and the following steps are taken to analyze it.

  1. Open csv file in Excel
  2. Save as XLSX
  3. Split Registry Name column into Mod ID and Registry Name
  4. Add column to detect duplicates; example: =IF(COUNTIF($B$2:$B$569,B16)=1,"No","Yes")
  5. Add filter to focus on "Yes" values
  6. Sort on Registry Name

Suggested change Create a script to scan the file and output the list of duplicates sorted by Registry Name Optional features: