Key Features
Automate your excel work
I will automate your excel work and formating using python scripts. Combine or split different excel-sheets / worksheets or add funcitonality. There i also the possibility to add data from other sources like json, html, xml, web, databases etc.
This will save you hours!
Python and the libraries are the ideal toolset for me to handle and transform the data.
As a hand-vetted Fiverr Professional i will automate your excel work and formating using python scripts. Not only i can combine or split different excel-sheets / worksheets i can also add funcitonality to the excel-sheet like calculations, aggregations, filtering, grouping, statistic, cleansing and much more. There i also the possibility to add data from other sources like json, html, xml, web, databases etc.
Project Examples:
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.
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.
