Welcome to the most exciting Excel automation script you'll ever meet! (Okay, maybe that's a stretch, but we're trying to make Excel fun here!)
This script is like your friendly neighborhood Spider-Man for Excel files - it swings through your sheets, catches all the important data, and weaves it into a beautiful consolidated web of information. Except instead of fighting crime, it's fighting manual data entry!
- ✨ Automagically finds participants across multiple sheets
- 🧮 Counts participations faster than you can say "VLOOKUP"
- 🎯 Handles those pesky "(Unverified)" entries like a boss
- 🚫 Ignores "Recording" and "Module" because they're not real people (sorry, robots!)
- 📊 Creates a consolidated sheet that'll make your boss think you're a Excel wizard
You'll need:
- Python (the programming language, not the snake 🐍)
- pandas (the data library, not the bears 🐼)
- openpyxl (for Excel magic ✨)
- numpy (for number wizardry 🔢)
- A sense of humor (optional but recommended)
pip install pandas openpyxl numpy
# Then do a little dance while it installs-
Put your Excel file in the same folder as the script (They need to be friends for this to work)
-
Run the script:
python process_certificates.py
-
Watch in amazement as your Excel sheets transform faster than a Transformer!
- If your Excel file is not friends with the script (wrong directory), it will cry
- If someone named themselves "Recording Module 1", they won't get a certificate (identity crisis much?)
- If your computer decides to take a coffee break mid-process, please give it a moment
If something goes wrong:
- Take a deep breath
- Count to 10
- Check if your Excel file is where it should be
- If all else fails, turn it off and on again (the universal IT solution)
- Sometimes gets excited and tries to give certificates to Excel column headers
- May occasionally mistake "Module" for a very enthusiastic participant
- Has been known to work so fast it makes manual data entry look bad
Found a bug? Want to make this script even funnier? Feel free to contribute! Just remember:
- Your code should be cleaner than your room
- Your commits should be more meaningful than your ex's apologies
- Your pull requests should be more polite than a Canadian
This script is licensed under the "Please Don't Blame Us If Your Excel File Starts Dancing" License.
Remember: This script was made with love, coffee, and a slight hatred for manual data entry. Use it wisely, and may your Excel sheets always be organized!
P.S. If this script saves you hours of work, we accept thank-you notes in the form of ⭐️s!
Made with 💖 by someone who really, really doesn't like copying and pasting data manually