Cleanup spreadsheets and create simple summary page and simple visuals
$150-300 USD
Paid on delivery
We operate a warehouse servicing a number of different book publishing imprints. Over 1000 titles and over 4000 pallets. We are in the midst of selecting a Warehouse Management System software. However in the meantime this will help us immensely in taking inventory and pulling larger [login to view URL] spreadsheet records the physical locations of palletized goods in the warehouse. Problem is that it doesn't total across all sheets, there is no front page summary. The existing spreadsheet design is somewhat [login to view URL] would also like to be able to import a batch of titles( 10-20 at a time) and the spreadsheet can tell us where the titles are most closely clustered together. Because this warehouse is floor stacked 2-4 pallets high, it will save us time if we can consolidate retrieval in general area or rows.
Feel free to tell us more about yourself, if you know the more advanced sorts of warehousing analytics and operations, there is a good chance we can use you on other future projects or to consult
Project ID: #24687807
About the project
Awarded to:
Hello, my name is Andres. I’m the data scientist of our team. I can create the tool exactly as you need it as I have an extensive background and experience using Excel, plus I started my career as a logistics busines More
52 freelancers are bidding on average $254 for this job
Hello, I am an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hello Sir Im excel VBA macro and formula Expert :) i can help you build spreadsheet in your warehouse management excel file. please ping me for discuss more and im free now Thank you Galih
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I am available to improve the file that you currently use More
Hi Mr. Vitor, i checked your files and understood clearly . I will make Visual Basic code as per your requirement with good and professional quality without any error. We can work together as earlier. If you want to a More
I am excel and VBA expert. I am interested in your project. I can do it easily. I have also data visualization experience. Malik
First of all, I hope you are well and healthy. Thanks for taking my proposal I have read your project and I can do it. I have worked with Nike's Memphis Warehouse Managing the inventories similar to your they use pall More
Hi, Keen to work on this project. Please suggest suitable time to discuss further on this requirement. I am well versed with Excel and its various features like Userforms, Pivot tables, HLookup, Vlookup, Countif, SUM More
Hi. I am ready to write your project. I have written many automation excel vba projects. Will complete within 3 days
Hi, I'm interested in your project I can create automatic overview sheet that pulls all the data from other sheets and show them in the format as you want. if you are interested we could have quick chat about details o More
My name is Lydia, I have been working on the computer for the last 15 years. My Top Skills are Excel, Microsoft Office and Internet Research.
Hi there, I have read your job description and I am ready to work for you. I am a certified IT professional and know well about computing tools and technologies and Web Searching, I also have 11 years of experience in More
Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end More
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 More
