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 program, put one folder called ' Aziz' in the desktop with the 2 excel folders ' Livedata1 & FixData' and run in the desktop too separately.
Hello,
I am Excel and VBA expert. I can do it (VBA)
Can I see sample RAW data file?
Please note that I have 100% completion rate and 5-star feedback on 50 projects.
The installation cost of wind farms can be said to be declining though at a slower rate than PV cells. The cost for a large scale on-shore units is around 1,000–1,500 €/kW which is a lot lesser than the cost for an off-shore unit since the latter involves installation in deep waters.
I am a data science engineer with programming experience in python,java,shell,R.
Being a data scientist i can easily detect the pattern of the data by having a first look at it.
Being a good programmer i can find out the best way to extract the needed data from the source.
I can apply my machine learning experience to bring out the pattern from the data and keep doing it without having you explicitly monitor it.
I can assure you the best results in an intelligent way.
I can do the job if you wanted me to continue your old worksheet or just wanted me to form another worksheet to work on just provide data and aim so I can accomplish the task.