Work Examples - Automate Your Excel Work and formating with python scripts
What:
Read football-statistics from a ms-access-db and provide the data in an
excel-sheet. Select several parameters before the program run like leagaue coffeeAndBeer
date-range
Used Modules:
pyodbc, xlwings
What:
Read inspections-list for aircraft vehicles, check the next service date regarding flight hours, cycles
and days
Used Modules:
xlwings
What:
Read source data for drivers with their stopps, duty hours, etc. and build summary-data and overview for every driver
Used Modules:
xlwings
What:
Parse contract-informations, and build a summary overview, input percentages for every employee and
detailed contract informations
Used Modules:
xlwings
What:
Read persons and provisions and build the output according to the titles, create a summary docx for
every person
Used Modules:
xlwings, docx
What:
Provide financial data from stock-titles from yahoo finance and gurufocus
Used Modules:
yfinance, selenium, xlwings
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings
What:
Run the program every few minute and check machine downtimes, register special downtimes and get an
hourly statistics output
Used Modules:
xlwings
What:
Create a working plan for creating beds and other furniture - select article, parameterize the step and create a working plan including pictures for the individual steps
Used Modules:
xlwings
What:
Create report for different students and show their strenghts, experience, rating, educaton, etc.
Used Modules:
xlwings
What:
Create a summary information for merchants and sydicates for a specific time and date
Used Modules:
xlwings
What:
Create forecast for different products, filter according to new products and end of life ignore lists and prepare binding window
Used Modules:
xlwings
What:
Create presence sheet for differet employees - getting all the start and end times and provide a report-overview with different measures
Used Modules:
xlwings
What:
Create and update a machine plan for different articles, products on different types of production machines
Used Modules:
xlwings
What:
Sort data in an excel-sheet - reading a master-list and splitting this to different worksheets, with changed columns
Used Modules:
xlwings
What:
Read revenue data from employees and create invoices with different parameters like tax, org benefits and recommendation bonuses
Used Modules:
xlwings
What:
Read supplier informations and build endcustomer prices with discounts for different package sizes, and colouring the price-span for every combination
Used Modules:
xlwings
What:
Group betting quotes in different categories and output the pattern for these patterns
Used Modules:
xlwings
What:
Calculate costs for a hotel in different categories and rooms
Used Modules:
xlwings
What:
Create some statistics for medical diagnosis reagrding health, family, social, age
Used Modules:
xlwings
What:
Analyze text for the occurence of different words and tagging noun, verb, adjective, etc.
Used Modules:
xlwings, textblob
What:
Search for links in several xml-files and show in which file which searchword can be found in an
excel-sheet
Used Modules:
xlwings, txt
What:
Read loans / expenses and create a classification overview for every month with the different types and
categories
Used Modules:
xlwings
What:
Clean phone numbers and streetnames so everything is written in the same way (street appreviation,
area code, etc.)
Used Modules:
xlwings, csv