Cleanup spreadsheets and create simple summary page and simple visuals

진행중 등록 시간: 3년 전 착불
진행중 착불

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

엑셀 Data Analytics Data Visualization Operations Research Logistics Power BI

프로젝트 ID: #24687807

프로젝트 소개

52 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

수상자:

trascenderglobal

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 기타

$300 USD (7일 이내)
(168건의 리뷰)
7.7

이 일자리에 대한 프리랜서 52 명의 평균 입찰가: $254

P0L

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.

$300 USD (5일 이내)
(466 리뷰)
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will calculate a series of figures across multiple shee 기타

$280 USD (5일 이내)
(333 리뷰)
8.0
prameswara

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

$300 USD (7일 이내)
(394 리뷰)
7.5
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed 기타

$300 USD (3일 이내)
(153 리뷰)
7.7
TonmoyRoy111

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

$400 USD (3일 이내)
(452 리뷰)
7.3
dgled

Hello, I am a financial expert and guru in Excel with extensive knowledge and expertise in advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashbo 기타

$300 USD (7일 이내)
(93 리뷰)
7.5
elqueabandona

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 기타

$300 USD (7일 이내)
(296 리뷰)
7.3
mtdevil369

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 기타

$150 USD (2일 이내)
(267 리뷰)
6.9
MohsanEijaz

I am excel and VBA expert. I am interested in your project. I can do it easily. I have also data visualization experience. Malik

$167 USD (2일 이내)
(94 리뷰)
6.5
urielbaray

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 기타

$250 USD (7일 이내)
(59 리뷰)
6.5
jkaranm

Hi Future Client, Thanks for sharing your project requirements with us. It will be our great pleasure to work on your project. I am one of the preferred freelancers in the site and referred by the freelancer staff to 기타

$300 USD (7일 이내)
(41 리뷰)
6.7
finecodervw

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 기타

$200 USD (4일 이내)
(74 리뷰)
6.2
writingapp

Hi. I am ready to write your project. I have written many automation excel vba projects. Will complete within 3 days

$320 USD (3일 이내)
(107 리뷰)
5.9
shahinrahimi

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 기타

$230 USD (4일 이내)
(61 리뷰)
6.1
LidijaP

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.

$300 USD (7일 이내)
(15 리뷰)
4.9
Xichiza

Hi, I am a senior BI consultant with over 3 years experience with Power BI and I can help you to concatenate your spreadsheets within power BI/power Query. I will use M language for the data cleansing and append the 기타

$278 USD (3일 이내)
(14 리뷰)
5.1
aymen90tahir

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 기타

$200 USD (6일 이내)
(10 리뷰)
4.7
nikhilgupta84

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 기타

$222 USD (2일 이내)
(7 리뷰)
4.5
hayteekeys

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 기타

$250 USD (1일 이내)
(9 리뷰)
4.2
plikitik123

im a developer and im gonna help create a software that you need

$750 USD (5일 이내)
(2 리뷰)
1.0