cloud
worklink

Work Examples - Automate Your Excel Work and formating with python scripts

iconFAQ

Find attached some projects i did in the past and Feedback from my customers.

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

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 Invoices

What:
Read revenue data from employees and create invoices with different parameters like tax, org benefits and recommendation bonuses

Used Modules:
xlwings

Calc Butcher Prices

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

Group Bet Quotes

What:
Group betting quotes in different categories and output the pattern for these patterns

Used Modules:
xlwings