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.
Change Excel-file (s)
What:
Change excel-file with different informations and also check zip-code specific informations
Used Modules:
xlwings
Arrange TV-Spots (s)
What:
Arrange tv-spots in an output-excel-sheet so its a best fit and the budget is not exceeded for the products
Used Modules:
xlwings
Handle Transactions Data (s)
What:
Read transactions-data from csvs and build report with categorization, summarization, etc.
Used Modules:
xlwings, csv
Bank Statements Dashboard (s)
What:
Read transactions from different bank-statements, categorize them and build some reports and dashboards out of it
Used Modules:
xlwings, csv
Merge CRM data (s)
What:
Merge 3 different leads csv-files out of a CRM-system, with informations for boxes, contacts and organizations
Used Modules:
xlwings
Create summary for farms and plots (s)
What:
Create a summary excel-sheet out of 2 other sheets with informations about different farms and different plots
Used Modules:
xlwings
Google Sheet Template for Therapy (s)
What:
Create a google sheet template for a therapy questionnaire for several clients a time protocol, detailed explanations and diagrams for visualization
Used Modules:
google sheet
Summarize Reports for Shops (s)
What:
Summarize different reports for shop, waterjet and machineshop with different employees and responsibilities
Used Modules:
xlwings
Create a Unit Cost list (s)
What:
Create a unit cost list for different materials and components with different price units and pieces
Used Modules:
xlwings
Check Timeslots (s)
What:
Check times ranges in which slots they are fitting for every scheduled work plan
Used Modules:
xlwings
Read Football Statistics (s)
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 (s)
What:
Read inspections-list for aircraft vehicles, check the next service date regarding flight hours, cycles and days
Used Modules:
xlwings
Driver Statistics (s)
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 (s)
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