Organize Evidence Files & Spreadsheet
Budget: $250 – $750 USD
My entire computer is packed with EEOC-related material—text documents, spreadsheets, PDF files, OneNote pages, and screen-snipping images—and it has become unmanageable. I need everything sorted, renamed, and cross-referenced so I can locate any piece of evidence in seconds.
Scope of work
• Locate every relevant file type listed above.
• Rename each file using the MM-DD-YYYY format I chose so the filename itself shows the exact date.
• Place the renamed files into a tidy folder structure that keeps the chronology clear.
• Create a master spreadsheet (Excel is fine) that logs each item. Every row must include: date, brief violation label, person(s) involved, and a clickable link that opens the file directly.
• Where possible, group or tag the same violation or person inside the spreadsheet for quick filtering.
Acceptance criteria
1. All specified files are present, renamed in the MM-DD-YYYY convention, and stored in clearly labeled folders.
2. The spreadsheet opens with no broken links and accurately points to every file.
3. Filters in the spreadsheet allow me to sort by violation or by person involved without additional setup.
You may use any standard desktop search utilities, file-management scripts, or Excel/Google Sheets features as long as the final directory and spreadsheet work on Windows 10. I’ll supply remote access or transfer archives once we agree on the workflow.
Scope of work
• Locate every relevant file type listed above.
• Rename each file using the MM-DD-YYYY format I chose so the filename itself shows the exact date.
• Place the renamed files into a tidy folder structure that keeps the chronology clear.
• Create a master spreadsheet (Excel is fine) that logs each item. Every row must include: date, brief violation label, person(s) involved, and a clickable link that opens the file directly.
• Where possible, group or tag the same violation or person inside the spreadsheet for quick filtering.
Acceptance criteria
1. All specified files are present, renamed in the MM-DD-YYYY convention, and stored in clearly labeled folders.
2. The spreadsheet opens with no broken links and accurately points to every file.
3. Filters in the spreadsheet allow me to sort by violation or by person involved without additional setup.
You may use any standard desktop search utilities, file-management scripts, or Excel/Google Sheets features as long as the final directory and spreadsheet work on Windows 10. I’ll supply remote access or transfer archives once we agree on the workflow.