Delete all installer files in this folder, i.e., files with the .dmg extension
Bonnie is deleting installer files
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 folder
Bonnie is generating pay stubs
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 date
Bonnie is summarizing invoice data
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 project
Bonnie is classifying invoices by type
Summarize the dates contained in these contract file names into an Excel sheet with two columns: file name and date. Sort by date ascending
Bonnie is summarizing contract dates
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 type
Bonnie is categorizing files by type
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
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
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
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
Merge these invoice PDF files into one PDF and rename it to 'JD Invoices - April Summary.pdf'
Bonnie is merging invoice PDFs