I am looking for an Excel wizard to help me with some Excel data rearrangement (see the attached excel file). Before bidding, make sure that you understand what the assignment is. Also make sure that you will be able to do this assignment. You can even put together a sample from the excel file attachment. This is a very simple project if you are familiar with excel and basic coding.
I am only paying after I am satisfied with your work. I am only paying $20 for this project.
Since the minimum that one can bid is $30, I want you to bid $30 when placing your bid. Keep in mind that you are only going to be paid $20….may be a bonus depending on the quality of the work.
SPECIFICATIONS
ScrubbedToolPlanData
1st Column=Tool Plans
• Consist of 1062 tools (FKTool) applied to 234 tool plans (column 1)
• Multiple tools (2nd column) in each tool plan
scrubbedToolDeployment
1st Column = Fk Tools
• Consist of all operation numbers (2nd column)
• Each tool can run multiple operation number per tool
scrubbedReleaseProfile_Orig
• Part per number (1st column) and the routes (2nd column) it has to take
scrubbedRoutes
• 1st column = route name
• Consist of all operation number s (2nd column) in order (3rd column) it runs
Task
Need to align the following:
1. Tool Plan with Tools in scrubbedRoutes sheet
2. Tools to operation number in scrubbedToolDeployment sheet
3. Operation numbers to routes in scrubbedReleaseProfile_Orig sheet
4. Routes to part number in scrubbedRoutes sheet
Want to see (going sheet to sheet)
Tool plans =>tools=>operation numbers=>routes=>parts number