Do some data entry

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

I have some work, in an Excel spreadsheet. I need you to create a visual, light and modern dashboard in Excel for a production area til 4/Sep.

The values should be visualized and main data to be shown too. Dashboard is presented by a projector and all info needs to fit to one page. Slicers/buttons can be used to shift between each line's data, but in this case I need a summary to show overall results too.

The dashboard is used to review the last 3 shifts' results vs plan on the startup meetings. Metrics are collected by the shift leader who enters the following values for each production line. Data to be shown for full day (3shifs) and for each shift.

Inputs and calculated values to be shown (data to be available on a separate sheet in a matrix for each line:

Input: Actual and planned volume (pcs) Calculated: BTS (%)

Input: Headcount - operators working on line, on vacation, on sick leave (heads) Caculated: absenteeism (%)

Input: OEE (%)

Input: Availability(%), Performance efficiency (%), FTT (%), Scrap(%), Scrap(EUR/piece)

Input: Labor efficiency - Actual & Planned (pcs/head/hour)

Input: Downtimes TOP 5 Pareto (minutes)

Input: FTT causes TOP 5 Pareto (pieces)

Input: Scrap causes TOP 5 Pareto (pieces)

Input: Scrap cost causes TOP 5 Pareto (EUR

I need a button also to the sheet. When the shift leader clicks it, the PDF version of the dashboard is sent to the email list specified on a separate sheet.

Excel

Nº del proyecto: #11432554

Sobre el proyecto

13 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

kolosibalint

Hi, I have 4 years experience in Excel VBA programming. I work as a data analyst at Ford Motor Company creating automated reports and dashboards on car sales figures. Could you please provide me with the a data sa Más

€200 EUR en 2 días
(109 comentarios)
6.8

13 freelancers están ofertando un promedio de €186 por este trabajo

Teloquence

Consider it done. Please check my past reviews for your reference. Looking forward for your reply so that i can start with the implementation.

€200 EUR en 2 días
(326 comentarios)
7.6
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Más

€500 EUR en 2 días
(209 comentarios)
6.8
ksriniravi

Greetings Hiring Manager! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting. In fact, over the last MONTH Más

€150 EUR en 3 días
(156 comentarios)
6.6
ChinmoySarker

Hi, Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. S Más

€34 EUR en 3 días
(21 comentarios)
4.1
vivirain

Hi, I have Excel reporting experiences & can help you complete this job. We can get in touch for details. Thanks, Best Regards,

€244 EUR en 2 días
(10 comentarios)
3.7
alpha2alpha

Hi sir, i have read your description and i am interested in your project., Spare me some time that we can speak about project. Waiting for your positive response

€211 EUR en 3 días
(4 comentarios)
2.9
arifulpritul

hello sir, I'm very helpful to work on it. please give a chance to prove it. I won't let you down. thank you!

€34 EUR en 3 días
(6 comentarios)
2.0
sriharish186

I AM RESOURCEFUL TO YOU IN THE SENSE THAT I CAN GIVE YOU MORE TIME FOR LESSER THE MONEY THAT YOU HAVE TO PAY

€34 EUR en 3 días
(0 comentarios)
0.0
saktulga

A proposal has not yet been provided

€72 EUR en 3 días
(0 comentarios)
0.0
giancarlo2000

I have more than 18 years of experience in corporate business, MS Office and PowerPoint. Design and creation of Operational and Executive presentations. I´m very interested on this project

€155 EUR en 3 días
(0 comentarios)
0.0