Inventory Analysis Expert in Excel
Budget: ₹1,500 – ₹12,500 INR
For my business, I am seeking an Excel wizard capable of building formulas and functions for analyzing data. This data originates from a pair of our inventory databases which need to be matched with incoming inquiries. These inquiries include specific fields such as make, model, part name, and part number.
Main Job Details:
* Creating Excel formulas and functions for the specified data analysis
* Focusing on indicating our inventory levels against these inquiries
The ultimate goal is to have you shift all matched rows to a separate sheet within Excel based on the analysis.
I am listing scenarios to solve for, by increasing complexity level
Matching with available part numbers (exact matches)
Matching with available part numbers (approx matches eg MAN B&W parts where the centre bit doesnt matter) Eg 123-05H-1235 is same as 123-11H-1235
Matching model + part names (exact matches), when part number is absent
Matching model + part names (equivalent matches), when part number is absent (eg fuel pump element = plunger). This might need use of dictionary capabilities
The ideal candidate for this job would be both highly experienced with Excel and comfortable working with large data sets. Those skilled in data analysis, detail-oriented, and capable of creating advanced Excel functions will be highly desired for this job.
Main Job Details:
* Creating Excel formulas and functions for the specified data analysis
* Focusing on indicating our inventory levels against these inquiries
The ultimate goal is to have you shift all matched rows to a separate sheet within Excel based on the analysis.
I am listing scenarios to solve for, by increasing complexity level
Matching with available part numbers (exact matches)
Matching with available part numbers (approx matches eg MAN B&W parts where the centre bit doesnt matter) Eg 123-05H-1235 is same as 123-11H-1235
Matching model + part names (exact matches), when part number is absent
Matching model + part names (equivalent matches), when part number is absent (eg fuel pump element = plunger). This might need use of dictionary capabilities
The ideal candidate for this job would be both highly experienced with Excel and comfortable working with large data sets. Those skilled in data analysis, detail-oriented, and capable of creating advanced Excel functions will be highly desired for this job.