Peter Listmann-Excel and Access Applications
Check rate
Experience
Calculator Overhaul
TD Synnex GmbH & Co. oHG
- Two suppliers made extensive changes to the calculations and data provisioning. Therefore, the calculation tool needs to be adjusted.
Database Optimization
HVU Bildungsakademie gGmbH
- An existing Access database is to be optimized, including structure, usability, and especially to achieve significant time savings in operation.
- The optimization should be done in steps because all data must be preserved and the changes have to be implemented during operation.
- The budget should be kept rather small.
- Used: Access, VBA
Inventory
MV E-Systems UG
- The company's product is made from a variety of individual components that need to be partially preassembled.
- To keep track of stock levels, orders, and purchases, a simple, low-cost Access database is needed.
- Used: Access, VBA
New Calculator
TD Synnex GmbH & Co. oHG
- TD Synnex needs a new calculator for another supplier. The existing (original) calculator is modified to represent the changed price list structure.
- Core features like simple item selection and creating customer calculators remain unchanged.
- Used: Excel, Access, VBA
Data Consolidation
COLIFT GmbH
- Personnel data from different sources are to be loaded into a single Excel "database". Formatting corrections are applied for a uniform presentation.
- Used: Excel, VBA
Income and Expenses
Fit4Business GmbH
- Clearly show income and expenses from account transactions, with comparisons, expense categories, and a view of how they change over time.
- Used: Excel
Three Excel Applications
BLM Büroservice GmbH
- Added and improved three small Excel applications.
- Used: Excel, VBA
Calculator/Report Redesign
TD Synnex GmbH & Co. oHG
- Made major adjustments after several changes by suppliers (source data, products, calculations).
- Responded to higher demands from country branches, requiring changes and expansions.
- Updated a report tool to work with new data sources.
- Used: Excel, VBA
Hotel Database
bikeAlpin GmbH
- Ongoing support, enhancements, and change requests.
- Used: Access, VBA, Excel
Hotel Database
bikeAlpin GmbH
- Created an Excel calendar application so the Access front end controls Excel and Excel controls the Access front end.
- Kept data clean in the Access back end, made it easy to change data in the Access front end, and gave an overview through an Excel calendar.
- Ensured maximum ease of use by having the target application already focused on the right records or cells when switching between Excel and Access.
- Used: Access, Excel, VBA
Calculator Redesign
TD Synnex GmbH & Co. oHG
- Change the calculation basis at a supplier from list price to Cost+.
- Completely rebuild the exchange rate calculation to allow offering any sales currency regardless of the purchase currency.
- Used: Excel, Access, VBA
Calculator Redesign
TD Synnex GmbH & Co. oHG
- Reactivate country-specific settings so that the local companies in Austria and Switzerland can use the changes to the tool.
- Used: Excel, Access, VBA
Heat Loss
ACE - Andrea Costa Engineering
- Add correct energy loss data to an existing Excel calculation tool. The calculations come from Andrea Costa, and I handled the Excel implementation.
- Used: Excel
Calculator Redesign
TD Synnex GmbH & Co. oHG
- The proven and heavily modified calculation tool must be significantly changed to map the completely new item structure of one supplier. At the same time, the change is used to implement performance improvements.
- Used: Excel, Access, VBA
Project Controlling
Nidec GmbH
- The annual presentation must be updated. This requires checking and possibly improving many analyses and charts. The goal is to both finish the presentation and identify and implement improvement opportunities.
- Used: Excel
Hotel Database
bikeAlpin GmbH
- The database, started in Jan. 2013 and improved and expanded over the years, needs to be completely rebuilt due to changed requirements. This includes a new data structure and, consequently, different workflows and output options.
- With the newly built structure, enhanced functionalities can be created that were not possible before. It also allows other time-saving workflows. Many limitations that previously required significant manual intervention are removed.
- Used: Access, VBA
Bill of Materials
Höckh GmbH
- Bills of materials from CAD and the ERP system need to be reconciled. The Excel tool highlights differences in color and lists them.
- Used: Excel, VBA
Reconciliation Files
TD Synnex GmbH & Co. oHG
- The Excel tool, developed between Nov 2018 and Mar 2019, had to be quickly converted to Access due to more records than Excel's row limit allowed.
- Used: Excel, Access, VBA
Various
Various
- Various minor adjustments and changes on different projects for several companies (e.g., TD Synnex, Audi).
- Used: Access, Excel, VBA
Patient Data
Julius-Maximilians-Universität
- Patient data from various research and monitoring systems needed to be combined into an Access database and exported together.
- Previously, viewing patient histories across different systems was not practical. The database now allows cross-system analysis for the first time.
- Used: Access, VBA, Excel
Invitation DB
Marketing Gesellschaft Mönchengladbach mbH
- Created an Access database to manage invitations for larger cultural events.
- Created invitations.
- Tracked responses (attending / not attending, with how many guests).
- Managed specific groups of invitees.
- Handled seat allocations.
- Used: Access, VBA, Excel
Contact Database
RuhrFutur gGmbH
- Built an Access database to manage all people RuhrFutur has been or is in contact with.
- Linked individuals with business partners (universities, ministries, companies, etc.).
- Connected projects with people or business partners.
- Created and managed lists (e.g., holiday mailings) for people at their business partners.
- Enabled export and selection options across all areas (people, business partners, projects, lists).
- Consolidated many separate Excel sheets into one database, eliminating duplicates, outdated data, inconsistencies, etc.
- Used: Access, VBA, Excel
Excel Pricing Tool extension
Tech Data GmbH & Co. oHG
- Improved the tool created from 03/2018 to 10/2019 and integrated supplier updates.
- Added additional functionalities.
- Improved performance.
- Addressed changes caused by suppliers.
- Used: Excel, VBA, Access
Green Tourism
Leuphana Universität
- Supported an Excel-based evaluation: compiled data on social and environmental criteria of package tours into an Excel tool and presented it visually. Evaluation logic created by Leuphana; analysis implemented in Excel.
- Used: Excel, VBA
IT Continuity
Audi AG
- Continued the project from 08/2017 to 11/2021.
- Changed the calculation basis.
- Enhanced graphical representation.
- Expanded reports.
- Provided support and advice on current topics.
- Improved data analysis.
- Implemented changes resulting from external requirements.
- Used: Access, VBA, Excel, PowerPoint
GMC Revision
MGS GmbH
- Revised and extended the "GMC" project from 12/2015 to 4/2016, and again in 12/2016 and from 5/2018 to 6/2018.
- Used: Excel, VBA
BCM Controls Consulting
KfW IPEX-Bank GmbH
- The Excel-based workflow was to be implemented in an Access database. Existing weaknesses were to be removed and the capabilities of a database leveraged. I provided pure consulting; another company handled the implementation.
- The client knows and values my solution approaches (from another project at a different company) and the very fast execution. The implementing company can benefit from my knowledge of BCM, spotting improvement opportunities, and unusual application scenarios in Access.
Price Lists 1
Tech Data GmbH & Co. oHG
- The supplier's monthly price list is automatically transformed to create an individual price list for selected customers.
- Used: Excel, VBA
TNW Automation
Schober Beratung für Logistik
- The consultants' monthly activity reports are automatically transferred into summary tables; plausibility checks are included.
- Used: Excel, VBA
Project Overview Extension
Hermes Arzneimittel GmbH
- Modified an existing Excel document to greatly improve editing and clarity.
- Designed the modifications so that other similarly structured documents can be easily upgraded and incorporated into a template.
- Covered selected topics in training on how to use Excel.
- Used: Excel, VBA
Excel Pricing Tool 2 / 3
Tech Data GmbH & Co. oHG
- Based on the existing Excel pricing tools, create another one to include an additional supplier.
- Used: Excel, VBA, Access
Excel Pricing Tool Enhancement
Tech Data GmbH & Co. oHG
- Extend the tool created from 03/2018 to 10/2019 by adding additional calculation methods (bonus models).
- Adapt the tool so it can be fully delivered to customers in their own corporate design.
- Add support for other languages (currently DE, in future at least EN).
- Used: Excel, VBA, Access
Scan Print
Wiesendanger medien GmbH
- Create a small Excel-based tool. A code is scanned with an RFID scanner, and the associated value from a CSV file is printed as a barcode on a label printer.
- Used: Excel, VBA
IT Continuity
Audi AG
- Continuation of the project from 08/2017 to 03/2020.
- Transition to a production environment.
- Create an extended calculation ("Impact Matrix") that provides significantly more accurate results.
- Add several reports.
- Add enhancements for a graphical view of the current state with notes on possible actions and prioritization.
- Used: Access, VBA
Excel Pricing Tool Enhancement
Tech Data GmbH & Co. oHG
- Enhance the tool created from 03/2018 to 10/2019 so it can be used in several country offices.
- Used: Excel, VBA, Access
Distance calculations
Schober Beratung für Logistik
- Calculate and enter road distances in an Excel sheet with start and destination locations using the Google Maps API.
- Used: Excel, VBA
Excel Macro Programming PMO
Hewlett-Packard GmbH
- Create or modify several small tools to process monthly time tracking internally.
- Used: Excel, VBA
GMC Overhaul
MGS GmbH
- Revise and enhance the "GMC" project from 12/2015 to 4/2016.
- Used: Excel, VBA
Excel Pricing Tool / Reconciliation Files
Tech Data GmbH & Co. oHG
- An existing Excel-based pricing tool had to be completely rebuilt. It generates a calculation interface from supplier price lists that takes into account the frequent dependencies and constraints and includes the customers' individual terms.
- For the first time, a tool that considers all conditions of both suppliers and offers simple, intuitive operation via filters and dropdown fields.
- Basis for long-term improvements and adjustments due to supplier changes.
- Extremely efficient tool for creating quotes, giving the internal sales team a unique selling point in the market.
- Selected customers receive their own tool that allows them to generate quotes or orders themselves. None of the competitors offers anything even remotely comparable, a massive competitive advantage.
- Created a tool to present monthly billing data for customers both summarized and in detail.
- Unrivaled presentation of business transactions for customers with the option to create calculations for end customers. The data volume no longer allows manual processing.
- Used: Excel, VBA, Access
Tours
Privat
- Create a private Access tour database to record and analyze sporting activities (mountaineering, road cycling, MTB, ski touring, …).
- Built to meet personal needs not covered by standard solutions.
- No dependency on standard software that the vendor might discontinue or shut down.
- Used: Access, VBA
IT Continuity
Audi AG
- Revised an Access database design and created the final Access database to manage, track, and calculate continuity processes.
- Contributed to the redesign of the underlying processes. Essentially rebuilt the Access database from scratch.
- Data that was previously compiled manually is now processed within seconds and converted into standardized reports.
- Changes can be made extremely efficiently thanks to a clean database structure. Significant staff savings while greatly expanding functionality and calculation accuracy.
- Provided a foundation for further rationalization measures and feature extensions.
- Tools used: Access, VBA, Excel, PowerPoint
Database Dictionary
Allianz AG
- Revised an Access database design and created the final Access database for documenting database fields.
- Tools used: Access, VBA
Development Support
EKM GmbH
- Implemented change requests and developed new features for various EKM clients.
- Software environment: GDI.
- Tools used: GDI
Cost Savings 2
GfK SE
- Completely rebuilt and functionally expanded the Access database worked on in May 2016.
- Tools used: Access, VBA
GMC Revision
MGS GmbH
- Revised and enhanced the "GMC" project from December 2015 to April 2016.
- Tools used: Excel, VBA
Hotel DB lists
bikeAlpin GmbH
- Revised the look of some lists and cover letters.
- Created a new list and customer letter.
- Used: Access, VBA
Hotel DB calendar
bikeAlpin GmbH
- Integrated a calendar to display all trips and guides for an entire season in Access.
- Added links from the calendar directly to edit the trips.
- Changes to the trips are immediately shown in the calendar.
- Used: Access, VBA
Equal Opportunity
Fraunhofer Society
- Automated a previously manual Excel tool to visualize key figures using VBA.
- Used: Excel, VBA
Hotel DB post-calculation
bikeAlpin GmbH
- Continued work from Dec. 2015.
- Used: Access, VBA
Cost Savings
GfK SE
- Got an existing faulty Access application running.
- Used: Access, VBA
Evaluation Tool
benchex GmbH
- Starting from an existing Excel solution, create a new Excel tool that lets you filter and summarize individual survey results and display the outcomes.
- Used: Excel, VBA
GMC
ais Werbeagentur GmbH
- MGS Munich Urban Renewal Company Ltd. needed an Excel-based solution to create a custom energy check for existing buildings for its clients.
- First "all-in-one" solution (Excel only).
- Free data entry with no quantity limits.
- The result is an approx. 30-page booklet that doesn't show it was generated with Excel.
- Used: Excel, VBA
Hotel DB Final Cost Calculation
bikeAlpin GmbH
- Expanded the hotel database to record and analyze all invoices.
- Used: Access, VBA
Training Management / Weclapp
Laufcampus GmbH
- Continuously add to and improve the application upgraded in Feb. 2015.
- Combine and clean about 10,000 addresses from different sources in Excel.
- Set up a database (together with the client) for the Weclapp CMS.
- Import the addresses into Weclapp.
- Used: Excel, VBA
CREDIT
Munich Re AG
- Modify the Access database created between July and August 2011.
- Upgrade to Office 2013 and Windows 7.
- Make minor adjustments.
- Used: Access, VBA, Excel
Training Management
Laufcampus GmbH
- Improved the functionality and appearance of an existing Excel file.
- Used: Excel, VBA
Jerseys
bikeAlpin GmbH
- Small Access database to get an overview of jersey sales by size.
- Used: Access, VBA, Excel
Hotel Database
bikeAlpin GmbH
- Made improvements to the database created last year.
- Used: Access, VBA
ENP Database / Renewal 2014 / MGA Monitoring Tool
Munich Re AG
- Created an Access database to manage risks with quarterly data imports from Excel and implemented a four-stage update process.
- Primarily reformatted Excel sheets of client claim data into machine-readable formats, partly using VBA tools I developed.
- Also created smaller tools, reports, etc.
- Converted the Excel solution created in April to May 2011 to Access.
- Used: Access, VBA, Excel
Hotel Database
bikeAlpin GmbH
- Built an Access database to book all trips, hotel stays, luggage transports, return trips, and shuttles.
- Created various lists and documents for customers and guides.
- Developed a calendar to overview the status of all trips.
- The new Access database made things much easier and set the foundation for many enhancements.
- Used: Access, VBA
Occupations Database
Munich Re AG
- Creating an Access database to manage occupational key figures.
- Connecting to an existing database via Excel interfaces.
- Used: Access, VBA, Excel
Renewal 2013 / CREDIT 2
Munich Re AG
- Primarily reformatting Excel tables of customer claims data into machine-processable formats, partly using custom VBA tools.
- Expanding the functionality of the database created in July and August 2011 and linking it to another Access database.
- Used: Access, VBA, Excel
Sampling
Techem GmbH
- Finalizing an Excel-based database to manage sampling points for water (legionella testing).
- Interface for data communication with the testing laboratory.
- Printing forms and sample labels.
- Used: Excel, VBA
Fahr & Spar Summer/Fall 2012
BMW AG
- Adapting the existing database to the conditions of an additional promotion.
- Used: Access, VBA
Fahr & Spar 2012
BMW AG
- Adapting an existing Access database to the requirements of this year's promotion.
- Migrating from Access 2003 / Windows XP to Access 2007 / Windows 7.
- Used: Access, VBA
Renewal 2012
Munich Re AG
- Mainly reformatting Excel sheets of customer claim data into machine-readable formats, partly using self-made VBA tools.
- Also creating smaller tools, reports, etc.
- Used: Excel, VBA
Maps
bikeAlpin GmbH
- Having maps scanned.
- Calibrating, cropping and stitching scans.
- Converting into various formats.
- Used: QuoVadis, GlobalMapper
CREDIT 2
Munich Re AG
- Creating a new Access database to monitor business transactions.
- Revising the existing Excel transfer front end.
- Converting the existing Excel database.
- Automating daily posting processes including reading data from Outlook, posting, limit checks and generating emails.
- Developing several reports to monitor business transactions.
- Through automation, for the first time gaining the ability to get exact data.
- Used: Access, VBA, Excel, Outlook
MGA Monitoring Tool
Munich Re AG
- Creating an Excel-based monitoring program that matches insurance data with claims data.
- Quarterly cumulative import of data delivery from the customer.
- Displaying about 30 KPIs, both in tables and charts.
- Adding an extensive filter.
- Used: Excel, VBA
Maps
bikeAlpin GmbH
- Creating digital maps.
- Calibrating, cropping and stitching scans.
- Converting into various formats.
- Used: QuoVadis, GlobalMapper
Renewal 2011
Munich Re AG
- Mainly reformatting Excel spreadsheets of customer claims data into machine-readable formats.
- Also creating small tools, analyses, etc.
- Used: Excel, VBA
Renewal 2010
Munich Re AG
- Mainly reformatting Excel spreadsheets of customer claims data into machine-readable formats.
- Automation resulted in massive time savings and elimination of manual errors.
- Used: Excel, VBA
Elevation Profile Generator
bikeAlpin GmbH
- Creating an Excel program to generate elevation profiles for the offered tours.
- Reading GPX files and providing layout options for the elevation profiles.
- Outputting scaled elevation profiles including point labels.
- Used: Excel, VBA
Order Processing
Fa. Schiedel / BTG Schornsteintechnik
- Production and distribution of chimney systems.
- Order processing.
- Creating and maintaining an Excel-based order form.
- Creating and maintaining an Access database for order tracking, production planning and coordination across multiple locations, including freight forwarding arrangements.
Asset Management Clerk
Bankhaus Merck Finck & Co
- Checking daily automatically imported account transactions and corporate actions.
- Manually updating corporate actions that cannot be automated.
- Preparing daily Excel reconciliations of internal settlement accounts: extracting data from print files, creating the account balances, and reconciling them with externally provided summary balances.
Export Order Processing
Ortovox Sportartikel GmbH
- Producing sports items for ski touring equipment, backpacks, and clothing.
- Creating production and demand plans with Excel.
Trainee Wholesale and Foreign Trade Specialist
F.W. Schubert GmbH
- Apprenticeship as a Wholesale and Foreign Trade Specialist in a work-integrated training program.
- Wholesale and Foreign Trade Specialist exam in May 1995.
- Train-the-trainer (AdA) exam in December 1994.
- Merchant in Wholesale and Foreign Trade exam in January 1994.
Surveying student
University of Applied Sciences studies
Military Service / Administrative Role
Bundeswehruniversität Neubiberg
- Basic training in Amberg.
- Administrative tasks in the student housing area at the Bundeswehr University.
Student
Asam-Gymnasium
- High school diploma with advanced courses in Mathematics and Physics.
Student
Sauerlach Primary School
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Education, Manufacturing, Construction, Automotive, Information Technology, and Banking and Finance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Operations, Logistics, Production, Business Intelligence, and Finance.
Summary
Creation and optimization of Excel and Access applications
- Extensive cross-industry knowledge
- Flexible and prompt implementation of your programming requests
- Attentive, dedicated, and structured work style
- All the advantages of an external contractor
Skills
- Windows Environments (Xp, Vista, Windows 7, Windows 10, Windows 11)
- Microsoft Office (2003, 2007, 2010, 2013, 2016, 2024)
- Excel Including Vba Programming
- Access Including Vba Programming
Languages
Education
F.W. Schubert GmbH
Certified Business Administrator (work-integrated program) · Munich, Germany
Surveying
Asam-Gymnasium
High school diploma · Munich, Germany
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Calculator Overhaul
Nearby freelancers
Professionals working in or nearby Holzkirchen, Germany
