Anbei einige Projekte die ich in der Vergangenheit umgesetzt habe:
-
Calculate a RSPO balance sheet. Seperate Admin-worksheet for the base-values.
And 2 worksheets for input and output where new trades can entered and then
calculated. Using a macro button to start the process in the exce-sheet.
-
Create calculation tool for window and door manufacturer. Input he dimension
of the different pieces and the overview gets generated. Different type of parameters
with different height and width, different materials and glass thickness.
All values are parameterized in a seperate admin-worksheet.
-
Create upload excel-sheet for amazon-products. Seperate the defined categories
which can be choosen as a parameter path and select the flat file names which
are exported from amazon an should be evaluated. Output-data will be created
and shaped as it needed. Additonal parameters for program-folder, categories
and flat files.
-
Excel-Sheet for the calculation of the profit per employee.
Cost for gas will be considered per tour and every time inputed by the user.
When the calculation is done, the earnings per tour and person will be
provided with the solution.
Automatisieren Sie Ihre Excel-Abläufe
Als zertifizierter Fiverr Professional automatisiere ich Ihre Excel-Prozesse und die Formatierungen in den Worksheets mit Python-Programmen. Mit ausführbaren Programmen für Windows oder MacOs kann ich beliebige Worksheets kombinieren oder teilen, aber auch Ihre Excel-Vorlagen erweitern um Kalulationen, Aggregationen, Filterungen, Gruppierungen, statistische Analysen und vieles mehr. Natürlich gibt es auch die Möglichkeit andere Quellen wie z.B. Json, HTML, XML, Web, Datenbanken zu ergänzen.
Automatisieren Sie jetzt Ihre Arbeit und sparen Sie Stunden!
Schauen Sie sich an was mein Kunden dazu sagen - Feedback
-
Make some construction calculations for different parts. Press the button as macro
in the excel-sheet and the calclation is done for several worksheets. Entry
possible in 2 different sheets with different permissions. 
-
Calculating for Frontsheet and Subsheets including a parameter possibility.
-
Scrape live data an create a stock value calculation including a chart.
Input an stock-ticker and the daily value and share amount get calculated.
Including calculation of some additional measures like ROI, Dividend Yield,
5Y Avg Dividend Yield, Yield Increase, EPS to Dividends etc. in a sepearte
Measure-Worksheet.
-
Package options calculator - read input data an create matrix for dependant
data entry fields. Calculate the package price including quantity amount
for every piece. Final price and monthly payments gets generated.
Program is startable with a button using a macro-call. Different worksheets to
handle at the bottom.
-
Create charts statistic for music-rankings. Read daily source-data for the charts
and calculate the report including position change, change 7 days diagram and
different volumen from last day / week. Made solution for daily and weekly charts
with corresponding input fields.
