In Progress

Do some data entry

I have a data analysis task. I need a dashboard built from the attached spreadsheet. This sheet is received daily. I want the dashboard to include the following metrics:

1. container counts in route by carrier, by origin to which destination. (i.e. Containers in route via APL, CMA, form origin SZX, SGN, etc). This metric should also have the total count in route.

2. Container counts in route for each destination (Dest) Englewood, Thornton, Firestone, Gilbert, Glendale, Grand Junction. This count does not need to include carrier or origin. Only totals.

3. Top 10 vendors with highest container counts in route

4. Top 5 vessels with the highest number of containers.

5. Containers received MTD

6. Average transit times from Actual Dept Date (COB) to Off Loaded Vessel for inbound shipments to Gilbert and Glendale, AZ. Average transit times for Englewood, Thornton, Firestone and Grand Junction must be calculated from Actual Dept Date (COB) to Arrived Dest Rail.

Note that duplicate container numbers must be removed before the dashboard is generated. The duplicates are included to indicate the POS associated with a container. The final destination is the same on these containers. This dashboard is to count containers, not POS.

Skills: Graphic Design, PHP, Website Design

See more: graphic design grand junction, graphic design az, duplicate data entry, data entry metrics, container graphic design, touch sight entry data entry job, php mysql entry data, google entry data, smart entry data, chapcha entry data entry, difference data entry data proceesing, data entry data conversation

About the Employer:
( 3 reviews ) Elizabeth, United States

Project ID: #10549280

Awarded to:

vbizsolutionss

Hi there, I’d like to be considered for your project position. I have read your job description and it has a great fit to me. I am very clear will all instruction which you have described. I would also like to menti More

$133 USD in 3 days
(4 Reviews)
2.2

9 freelancers are bidding on average $118 for this job

gauravmittal1989

Hello, how are you? I saw already your description. Your project is very suitable for me. I have great skills in HTML, PHP, Website Design and Graphic design . I think that if you believe and award for me, i will finis More

$135 USD in 3 days
(20 Reviews)
4.5
Ibrahim185

Hi, After reviewing the project description I know that I'm an excellent fit for this [login to view URL]'s discuss and start right now. Awaiting for your positive reply thanks.

$155 USD in 5 days
(18 Reviews)
4.0
$100 USD in 3 days
(3 Reviews)
3.3
infosoftgoway

Hello I am software developer of php technologies , I have 6+ Exp in php and different technology, [login to view URL] , Wordpress, Joomla, Mengendo.etc.. [login to view URL] Technologies 3. C, C++ , Core Java , Advanced Java , Python 4. More

$66 USD in 3 days
(4 Reviews)
1.2
luckykashyap

Hello, Greetings of the day! I have gone through the job description carefully and you’d be glad to know that the skills you are looking for are right up my alley and i am very much well equipped to do data analysi More

$150 USD in 3 days
(0 Reviews)
0.0
$277 USD in 3 days
(0 Reviews)
0.0
gretchencalamba

I am Gretchen and I already had experience working in Amazon as Data Entry in their product to create a keyword and I am also expert in MS Excel, PP and Publisher, I am also expert in Adobe Photoshop for making a Weddi More

$155 USD in 3 days
(0 Reviews)
0.0
alexsawork

Hi I am new to freelance, so I do not have reviews here yet, but if you hire me, i will be happy to provide a discount for a review. i have over 8 years of PHP development experience. i can complete your task in 2 d More

$111 USD in 2 days
(0 Reviews)
0.0
$60 USD in 3 days
(0 Reviews)
0.0