Program an Excel Sheet with a Dynamic Dashboard

종료 등록 시간: 3년 전 착불
종료 착불

Company: Multinational large-scale FMCG

Timeframe: 1 week with a proposed dashboard look in a few days.

Deliverable: Fully functional coded excel sheet with an updating dashboard to represent progress. Ideally with a feature to submit and update individual entries.

Given data sample sheet attached below, I need an excel file (with a dashboard) wherein we can continually add data like the sample. The dashboard should be able to summarize the data points of the sample. Will be needing the dashboard to show:

1. how many stores were added this month

2. how many stores are assigned or unassigned

3. how many stores have been tagged

4. How many stores have been onboarded

5. Year to date and month to date progress report

6. Division of stores per category (how many % of total are specialty stores, how many % carry HC, etc.)

엑셀 비쥬얼 베이직 데이터 처리 PHP

프로젝트 ID: #26350657

프로젝트 소개

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

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

AnowarRatul

Hello sir, I have read your project details and reviwed attachment carefully. I can make Program an Excel Sheet with a Dynamic Dashboard by maintaining 100% accuracy of your data absolutely as you want ------VBA Macr 기타

$250 USD (5일 이내)
(360 리뷰)
6.7
aimefx

Hi, I am an expert in expert in excel. I have checked the attached excel file there is not date column to calculate month, month to date, year to date etc. please can you send me complete data. Thanks

$140 USD (7일 이내)
(105 리뷰)
6.3
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. I can develop a fully 기타

$249 USD (6일 이내)
(174 리뷰)
6.3
merinsinha

Hi i am an certified excel VBA expert. Hi i can do it. For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i ca 기타

$300 USD (1일 이내)
(142 리뷰)
5.6
IgeS

Hi there, Need an Excel workbook with these features - adds batch entries or an entry, updates or modifies an Entry; and summarizes the five criteria in the job post thru Dashboard? Please message me if this is any 기타

$100 USD (7일 이내)
(44 리뷰)
5.5
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$90 USD (1일 이내)
(25 리뷰)
5.0
shivaparvathi108

Hello I am Nathiya. I have lot of experience working in VBA, .net excel add-in. I am also a BI analyst. Have experience working in BI tools like Power I BI, Spitfire...etc. I completed many projects in this area. T 기타

$30 USD (3일 이내)
(32 리뷰)
4.3
muhammadumar84

Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for an expert in excel for dashboard. please visit my profile for reviews on similar assignments. My Profile: 기타

$30 USD (1일 이내)
(14 리뷰)
3.4
DHAVALPATEL008

Only 140$ in 2 days-Lowest bid with a high potential solution-Payment after 100% Work satisfaction I have gone through your current requirements Excel Sheet with a Dynamic Dashboard & happy to provide the required s 기타

$140 USD (2일 이내)
(2 리뷰)
3.4
raffayharoon

Hi, I am an expert in excel. I have a passion for data visualisation. I can make complex and dynamic graphs and charts. I can make an elegant dynamic interactive dashboard. I am also an expert in vba and macro programm 기타

$80 USD (4일 이내)
(10 리뷰)
2.8
shekmodi

Hi there, Hope you are taking care of yourself. I am Abhishek, a professional data scientist with 5 years of experience working with data to create compelling data stories. You can check out my profile for the portf 기타

$125 USD (7일 이내)
(6 리뷰)
2.5
xixdia

Hi, I have 15 years experience as Supply Chain analyst. My main competencies are, Excel and creating overviews. I am used to use Access as database for my Excel sheets. I am ready to start. I need a some more info bef 기타

$150 USD (4일 이내)
(2 리뷰)
2.6
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 기타

$120 USD (7일 이내)
(3 리뷰)
2.6
maryum25

Hi, I have gone through your requirements for this excel project and would like to facilitate with my expertise. Kindly share any further details in PM to proceed further. I am open to negotiate on project timelin 기타

$222 USD (7일 이내)
(1 리뷰)
0.0
Franz0603

Hi Good day! I can make you a spreadsheet dashboard, which you will able add and edit! And the report is automatic genetared using Pivot Tables! Relevant Skills and Experience With more than 12 years experience in 기타

$111 USD (3일 이내)
(0 리뷰)
0.0
mahi123bora

HI I am a professional vba developer having 6 years if experience in coding . I have created several dashboards and can perform this task easily. Please let me know when can we start.

$150 USD (7일 이내)
(1 리뷰)
0.5
sssaravana1198

Hi sir, I have gone through your project description and I am very much interested in doing your project. I am sure I’ll exceed your expectation so please give me chance Thank you

$50 USD (1일 이내)
(0 리뷰)
0.0
KaranSharmaB

Hello , i' m Karan S. i have good skills to complete your task . i can do it and i will make sure that you are happy with my work . please share more detail regarding your task. regards Karan S.

$50 USD (2일 이내)
(0 리뷰)
0.0
Princekr6006

I want data entry in excel , i am fresher Relevant Skills and Experience I want data entry job i am fresher

$167 USD (3일 이내)
(0 리뷰)
0.0
irvan

dear sirs. i have read your requirement. i had knowledge building reporting dashboard for telecomunication company in indonesia using microsoft excel . feel free to contact me so we can discuss further

$278 USD (14일 이내)
(0 리뷰)
0.0