Hallo, für eine Datenauswertung suche ich Unterstützung von einem Excel-Kenner. Ich kenne mich leider gar nicht damit aus.
Folgende Aufgabe:
Ich habe eine Excel-Tabelle mit folgenden Daten. Ich habe die richtige Vorlage zum Verständnis auch angehangen.
Zeile -- Kunde --- Produkt --- Datum --- Menge
1 PersonA Lebensmittel1 22.02.2020 100
2 PersonB Lebensmittel2 23.02.2020 1000
3 PersonA Lebensmittel1 24.02.2020 110
4 PersonB Lebensmittel2 25.02.2020 1100
Was ich möchte:
Eine weitere Spalte, in der die Veränderung der Menge eines Lebensmittels dargestellt wird. Sprich in Zeile 3 müsste am Ende +10 stehen und in Zeile 4 +100.
Zu jeder dieser Zeile gibt es noch z. B. 10 Werte:
300, 320, 340, 360, 380, 400 usw.
Hier hätte ich gern den Startwert, Endwert + Prozentuale Veränderung.
Also z. B. Start: 100 Ende: 200 +100%
Und jetzt kommt noch Mathematik ins Spiel: Ich würde gern die Schwankung innerhalb des Verlaufes sehen. Also in der Zahlenreihe oben ist es linearer Verlauf= Schwankung gering.
300, 220, 340, 100, 380, 400. In diesem Beispiel aber:
Start: 100 Ende: 200 +100% Schwankung sehr hoch.
Ich habe die Datei mit den Beispieldaten angehangen und freue mich über den Support.
Hi, how are you?, my name is Cristian and i am Excel/VBA expert.
You can see my previous work and the comments that employers have left me in the following link: https://www.freelancer.com/u/elqueabandona
Contact me to discuss the details. Cheers
€50 EUR in 3 Tagen
5,0 (258 Bewertungen)
7,0
7,0
9 Freelancer bieten im Durchschnitt €38 EUR für diesen Auftrag
Hello,
I read your project description very carefully. I think i am the best freelance for your project. My main skills is under below...
Web scraping
Data Entry
virtual assistant
Email List Building
Lead Generation
PDF to Word/Excel
Social media management
Blog/Article/Content posting
I can start work right now.
The Price is Negotiable
I will give you 100% accurate task and 24/7 days supports.
Hi, I'm a professional and expert in Data works or projects..My skills and services include:
- Web scraping
- Data entry
- Data mining
- Data processing
- Excel
- MySQL
- Oracle
-Financial Analysis
-Advanced Excel
-MS Office
-Python
-PowerPointMacros
-Automatioin
-Automation tools
-PowerBI
-VBA
-Excel and VBA automation
- etc.
A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level.
I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project.
I only accept the projects which I am sure can be done within the stipulated time frame and budget..
I always deliver 100% Satisfaction to the client.
Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat.
Thanks
Regards
ATEMENU.D
Hi, I want to work with you. I have excellent access to the Entry Data section and I can help and work with you. Please accept my offer and let me know about the duties.
Hello, i have read the description of the project, and i assure you i am the suitable freelancer to complete this project on time. Let me know furthermore
Hi, i read your project and i am very much interested for being hired for this project.
Work will be done according to your needs and requirements.
Work on time with 100% accuracy.
Love to build long-term relations.
REGARDS,
THANK YOU