Automate your excel work and formating with python scripts with combining, splitting, converting whole excel-sheets. Or calculate, aggregate, filter, group change, visualize and clean the data as you need it.
Read Football Statistics
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
Aircrafts Inspection
What:
Read inspections-list for aircraft vehicles, check the next service date regarding flight hours, cycles and days
Used Modules:
xlwings
Driver Statistics
What:
Read source data for drivers with their stopps, duty hours, etc. and build summary-data and overview for every driver
Used Modules:
xlwings
Parse Contracts
What:
Parse contract-informations, and build a summary overview, input percentages for every employee and detailed contract informations
Used Modules:
xlwings
Create Provisions
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings, docx
Financial Overview
What:
Provide financial data from stock-titles from yahoo finance and gurufocus
Used Modules:
yfinance, selenium, xlwings
Syndicate Summary
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings
Check Machine Downtimes
What:
Run the program every few minute and check machine downtimes, register special downtimes and get an hourly statistics output
Used Modules:
xlwings
Create Working Plan
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
Student Overview
What:
Create report for different students and show their strenghts, experience, rating, educaton, etc.
Used Modules:
xlwings
Merchants and Syndicates
What:
Create a summary information for merchants and sydicates for a specific time and date
Used Modules:
xlwings
Forecast With Binding
What:
Create forecast for different products, filter according to new products and end of life ignore lists and prepare binding window
Used Modules:
xlwings
Presence Overview
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
Machine Operating
What:
Create and update a machine plan for different articles, products on different types of production machines
Used Modules:
xlwings
Sorting Worksheets
What:
Sort data in an excel-sheet – reading a master-list and splitting this to different worksheets, with changed columns
Used Modules:
xlwings
Create Trade Statistics
What:
Create a customized excel-sheet for trade statistics with Trades, Easiness of Getting Along, Rediential vs. Commercial, Contact Person, EMail, Website, etc.
Used Modules:
xlwings
Create List Template
What:
Read some input-information and create a list-template for further use
Used Modules:
xlwings
Process ERP Data
What:
Process some ERP-data and match some additonal information from 2 other system in a final list
Used Modules:
xlwings
Add Summarization With OpenAI / ChatGPT
What:
Add summarization for longer text and update the files
Used Modules:
openai, dotenv, xlwings