Data stock improvement (Excel /Python)
€8-30 EUR
Paid on delivery
I’m an industrial engineer, I tried to set up a program for this but it’s too complicated for me to achieve this work.
60% of work is done until now because I can run the program for one worksheet. But I cannot do it for the rest because other worksheets are not similar to the first one.
Every spare part in our stock is represented by one box into the Excel Data and localized like this:
30 D 002181
30 D : Area
21 : Location
8 : Level
1 : Position
We get into the meet of the project:
Project Goal: Create a basic program to clean up and do inventory automatically for every area.
I have 2 Data:
LiveData: Excel with one worksheet.
Every morning, I receive by email all spare parts that we have in stock (Real stock).
FixData: Excel with many worksheets (Every worksheet represents one stock area).
I tried to map all areas (one by one), so it’s ok.
I still have small problems (Areas don’t have same criteria).
• Number of sections per worksheet
• Sometimes section number is an even, sometimes it’s an odd and sometimes it’s both (It’s the case of the first worksheet).
• We don’t have same column number per section for every area.
So, what I’m wondering now to do is:
Do the same work that I did for 30&32 D for all areas.
And set up a menu to allow to the final user to choose one area and run the program automatically for this one.
To run the current program, put Livedata1 and FixData in one folder called 'Aziz' in the desktop and run separately in the desktop too.
Project ID: #11852037
About the project
16 freelancers are bidding on average €48 for this job
Greetings! If it is acceptable to you I can do the entire solution in Excel (instead of Python). I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of More
We can implement it using google API and implement using python. Let me know the best of your time to discuss so we can move forward to the next level.
Hi, I can do this either in VBA or python. Which ever is convenient to you. Let me know if you ok with the bid value. Thanks, Rajeev
Hello. I can complete your job with the lowest budget and shortest time. I am an experienced accountant and familiar with Excel as well as macro. I am willing to work at low wage rate. Hire me!
• 14 Years Technical Lead / Project Lead / Development Head experience in most recent java technologies. • Expert Knowledge in wide variety of technical areas: Operating Systems, Databases, ESB, Design Patterns, Tools More
