Doherty Automation

In this example we have the emails of applicants stored in PDFs. However, it would be helpful to have this data in a spreadsheet. Using a custom Python program we can open each file, extract the email address, and output to a spreadsheet or CSV all with one click! 

Here we have a Excel sheet of orders. Every existing order that has a quantity less than 10 needs a minimum quantity fee of $5.00. We can use an Excel macro to add this fee everywhere it is required. Once again, hours of sorting through data reduced to one click!

In this example we also have a list of orders. The unit price of each item varies depending on the quantity ordered. The unit prices should be:

$100 for 9 or less

$90 for 10 to 99

$80 for 100 to 499 

$70 for 500 or more

I can make a custom Excel function that does this. The name of the function could be something like “Qty _Discount” and we can use it similarly to the “SUM” or “Vlookup” functions. No more searching for non-existent or difficult to use functions!