build me an excel dashboard that is integrated with another excel file

Đã Đóng Đã đăng vào 3 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

i own a factory and i have a big storage area other than the warehouse to store raw materials. so i would like to find a way to create a database that could calculate how many pallets i could store in one area given the max capacity and total consumption of my factory

for example i have a pallet of Raw Material X (800 KG) and i have an area that stores up to 80 pallets of RM X. physically i can check it, but i want a dashboard whenever i place my data i will directly get the number of empty space, the quantity of raw materials and finally whether they are important or not.

based on this data i could either expedite some orders according to inventory availability, or decrease the orders.

P.S data are private and can't be shared, so this would prove to be a headache.

[Removed by Freelancer.com Admin]

Excel Microsoft Access Xử lí dữ liệu Nhập liệu

ID dự án: #26754207

Về dự án

40 đề xuất Dự án từ xa 3 năm trước đang mở

40 freelancer chào giá trung bình$393 cho công việc này

schoudhary1553

Hi, Greetings! ✅checked your project details: build me an excel dashboard that is integrated with another excel file ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the Thêm

$400 USD trong 5 ngày
(442 Nhận xét)
8.4
asin1987

Dear Employer, I understand you need an Excel Dashboard which will show you how much quantity can be stored in your Warehouse depending upon the weight of the material. Please message me to discuss further, I will do Thêm

$444 USD trong 2 ngày
(252 Nhận xét)
8.1
seoguru17

I can create a Dashboard for your Warehouse. I would like to discuss to understand all your requirements, lets chat

$500 USD trong 7 ngày
(105 Nhận xét)
6.7
zu02

Hello I hope all's well with you. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Really most of my projects I've developed in freelancer.com . Please visit :https://www.f Thêm

$750 USD trong 7 ngày
(63 Nhận xét)
6.4
JohnRikz

Hello there, I'm your perfect candidate as all my experiences and achievements are within your requirements as I specialize in operations and logistics. Although my profile is new on freelancer, my practice is not. Thêm

$400 USD trong 7 ngày
(82 Nhận xét)
5.5
ajaykumar0701

I have worked in operations of a company producing electrical motors through assembly line. I have fair knowledge of raw material and finished good storage and effective management through pallets and bins. I can use e Thêm

$300 USD trong 5 ngày
(10 Nhận xét)
4.6
luassaf

hello! I have more than 10 years of experience with Excel, creating different types of dashboards and other tools for the high management. I understand your request, and the complication that you describe. In order t Thêm

$250 USD trong 3 ngày
(7 Nhận xét)
2.9
vinodk132

Greetings, Throughout my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources an Thêm

$300 USD trong 7 ngày
(3 Nhận xét)
2.6
Pawan7292

I have 5 year experience in Microsoft software. I do this work in low cost . Give me chance and share me your project details. I will complete your work within a day. I will start your project right now. Have a good d Thêm

$250 USD trong 1 ngày
(4 Nhận xét)
2.1
KPrafful

Hello, I have read your requirement and what I think is that you need a VBA/Macro program that will run in your excel and based on your input it will calculate and give you the required result in same /different excel( Thêm

$250 USD trong 4 ngày
(5 Nhận xét)
2.2
Exceltechguru

Hello Client, Greetings I am Excel Expert with an experience of working with excel for more than 15 years. I will be able to create dashboard in excel. I have already created dashboard in excel which you can view in my Thêm

$250 USD trong 3 ngày
(2 Nhận xét)
2.3
abinayaabi2018

I WILL DO MY JOB PROPERLY AND DO THE JOB YOU GIVE ME WITHOUT ANY DELAY OR ANY MISTAKES TRUST ME ON TOP

$500 USD trong 7 ngày
(0 Nhận xét)
0.0
atATHUL

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate on Diploma In Computer Application. And good knowledge in all MS softwares I am Thêm

$250 USD trong 4 ngày
(0 Nhận xét)
0.0
skaslam786

Hello, My name is Aslam. I am happy to be a member of the Frelancer community. My goal is to provide the best services possible to all of my clients. I offer 100% guaranteed satisfaction to all my clients when one is n Thêm

$250 USD trong 7 ngày
(0 Nhận xét)
0.0
begumkurun7

I worked several years as; * Keeping regular reports updated and sharing monthly analyses accordingly * Developing new tools to track and summarize data * Modeling to determine new KPI’s and distribute them to team mem Thêm

$400 USD trong 5 ngày
(0 Nhận xét)
0.0
chavanshubham7

I am expert in such field. Already done an inventory system for a firm which dealt in curtain and other accessories. I can do the same.

$750 USD trong 7 ngày
(0 Nhận xét)
0.0
cholkerj

I am an experienced Finance & Accounting Professional with MBA Finance & CMA Qualifications. I have good experience in Excel working and would be able to build Financial Spreadsheet for your mortgage business, as per Thêm

$500 USD trong 2 ngày
(0 Nhận xét)
0.0
krbr2002

I am interested to do this task. I'm having 13 experience in this field. Give me an opportunity to serve you.

$250 USD trong 5 ngày
(0 Nhận xét)
0.0
khairulbasar1

This is production and storage management problem. We do have such theory and software algorithm to calculate the value to inventories and empty space calculation. How, can we get sample data because that's important f Thêm

$355 USD trong 7 ngày
(0 Nhận xét)
1.0
cristymay

I am a graduate of Accountancy. I have knowledge about the nature of inventory and what are the specific data that should be indicated in the Excel for tracking purposes. Relevant Skills and Experience I am managing Thêm

$333 USD trong 5 ngày
(0 Nhận xét)
0.0