For Everyone | Delete Unused Installers in Downloads
Bulk Delete Installers
Delete all installer files in this folder, i.e., files with the .dmg extensionBonnie is deleting installer files
Corporate Finance | Generate Individual Pay Stubs for Each Employee
Batch Generate Pay Stubs
Based on the data in this spreadsheet, create an individual Excel pay stub file for each person. Each pay stub should contain two rows: headers and content. The file name should be the person's name. Put all generated files into a single folderBonnie is generating pay stubs
Enterprise Finance | Summarize Invoice Data into an Excel Sheet in Bulk
Batch Invoice Data Summary
First, use a PDF reader to read the text content of these invoice PDF files. Then call OpenAI to recognize and understand the text. Finally, summarize the invoice information into an Excel sheet, keeping seller name, item name, total amount with tax, and issue date. Sort the rows by dateBonnie is summarizing invoice data
Corporate Legal | Categorize Invoices by Project Type
Classify Invoices by Project Type
First, use a PDF reader to read the text content of these invoice PDFs. Then call OpenAI to recognize and understand the text. Finally, classify the invoices according to the detected project information, placing different types into different folders named after the projectBonnie is classifying invoices by type
Enterprise Legal | Summarize by Date in Contract File Names
Summarize by Contract Filename Date
Summarize the dates contained in these contract file names into an Excel sheet with two columns: file name and date. Sort by date ascendingBonnie is summarizing contract dates
Content Creators | Quickly Categorize by File Type
Quickly Categorize by File Type
Categorize these files by type, such as mp4, xlsx, png, etc. Put files of the same type into one folder, and name the folder after the file typeBonnie is categorizing files by type
University Teachers | Rename and Consolidate Transcripts by Class
Rename Transcripts with Class Prefix and Consolidate
Add the class name as a prefix to all Excel file names in this folder; for example, rename 'Cao Kun.xlsx' to 'Class 2-6 - Cao Kun.xlsx'. Save the renamed Excel files to a new folder named 'All Transcripts for Class 2-6'Bonnie is renaming and consolidating by class
Enterprise Legal | Append Last Modified Date to Contract Filenames
Append Last Modified Date to Filename
Add the last modified date of these contract files to the filenames. For example, rename to '20250324- Simen Authorization Agreement.docx'Bonnie is appending last modified dates
Content Creators | Batch Compress Images to a Consistent Size
Batch Compress Images to a Consistent Size
Compress these images so that each is around 50 KB. Save the compressed images to a new folder named 'Compressed Images'Bonnie is batch compressing images
Content Creators | Batch Convert Image Formats
Batch Convert Image Formats
Convert all these images to the JPG format. Save the converted images to a new folder named 'New Images'Bonnie is batch converting image formats
Office Staff | Merge Multiple Invoices into a Single PDF for Reimbursement
Merge Multiple Invoices into a Single PDF
Merge these invoice PDF files into one PDF and rename it to 'JD Invoices - April Summary.pdf'Bonnie is merging invoice PDFs