Multiple projects tracking on one dashboard with excel data

  • Статус: Open
  • Винагорода: $400
  • Надіслані роботи: 5
  • Переможець: amwazeindia

Стисле описання конкурсу

I am a project manager and my team have multiple projects to handle. Projects comprises of different customer with different project creation/allocation dates, start and completion dates.

This dashboard shall be able to showcase the number of ongoing projects, project overdue/delayed.

In sample data attached, there are multiple projects (customer sites), there can be one system used at one project site or multiple type of systems use at same site.

Important details for calculation and shown in dashboard as such:
1) Number of ongoing projects
2) Number of projects delayed
3) Numbers of projects cancelled
4) Number of projects completed within 6 months/1 year (It will be good if dashboard perimeter can be changed to 3 months or any other variants). This shall be Project start day minus Project End date)
5) Number of on-going projects - days calculated till date, from project start date. Rank of the project that is taking most days and months.
6) Days between job creation date and project start date.
7) Engineers who took lesser time to start a project (project start date - job creation date)
6) Number of projects per engineer
7) Engineers ranking on days took to complete a project.
8) Total project value.
9) Individual engineer project value

Any other not shown in sample data but good to have
1) by input of project completion forecast date in a field, project value forecast can be calculated.

Other good suggestion can be provided and i will up the payment
Additional feature if this data and dashboard can be simple use on iphone for presentation.

Рекомендовані навички:

Найкращі роботи цього конкурсу

Переглянути більше заявок

Публічна роз'яснювальна дошка

  • Haseebahmed243
    Haseebahmed243
    • 12 годин(и) тому

    check #66

    • 12 годин(и) тому
  • DHAVALPATEL008
    DHAVALPATEL008
    • 14 годин(и) тому

    Hi Requesting you to please mention the reason for rejecting so we can come up with the best solution

    • 14 годин(и) тому
  • DHAVALPATEL008
    DHAVALPATEL008
    • 3 дні(в) тому

    The requirement of the dashboard is in excel only or other tools like Power BI, R, Tableau can also be used?

    • 3 дні(в) тому
  • DHAVALPATEL008
    DHAVALPATEL008
    • 3 дні(в) тому

    Hi

    • 3 дні(в) тому
  • TheKingOfCode
    TheKingOfCode
    • 4 дні(в) тому

    Hi there, I have a few questions to start:

    - Do you use a unique table with all the data, or use multiple tables?
    - Is it possible to add at least two days to the deadline?

    I'm an experienced software developer (+8 years), and I can create a dashboard that works on Desktop and Mobile for you, with great UX/UI, but I need at least two more days.

    Cheers

    • 4 дні(в) тому
  • imfarrukh47
    imfarrukh47
    • 4 дні(в) тому

    need answer for these questions
    1) what is the criteria for calculate project delayed there is no expected completion or date?
    2) what is the criteria for project cancelled as no column for project cancel?

    • 4 дні(в) тому
  • kdmedev
    kdmedev
    • 5 дні(в) тому

    Looking at the sample data you gave. Can you elaborate what each field represents and how they relate to each other?

    • 5 дні(в) тому
  • emircanerkul
    emircanerkul
    • 5 дні(в) тому

    Please wait, i'm working on great piece.

    • 5 дні(в) тому
  • DHAVALPATEL008
    DHAVALPATEL008
    • 6 дні(в) тому

    We can go with the google spreadsheet dashboard so it will easily live available on mobile also.

    • 6 дні(в) тому
  • blui88
    blui88
    • 6 дні(в) тому

    Kindly share your thoughts about my Idea shown in Entry# 15.
    With kind regards
    Santosh

    • 6 дні(в) тому
  • blui88
    blui88
    • 6 дні(в) тому

    Hi,
    I am keen interested to know more about this project before starting in a right direction.
    I have few questions in my mind.
    Are you either interest in creating Dashboard reports using raw data in excel (already managed separately) or want a complete system capable to add and manage raw data then generate reports as per your requirement?
    One more thing, if you are looking for complete system(this is my suggestion to manage things in one system, instead of managing in two.
    How would you feel to see a complete system to mange things( from start to hands off of project ) data management in on system based on MS Access with VBA?
    I have already worked on this type of project.
    Kindly share your thoughts so we move our next step towards achievement of our goal.
    Thanks and regards.
    santosh

    • 6 дні(в) тому
  • abdulrazakZakieh
    abdulrazakZakieh
    • 1 тиждень тому

    Dear contest holder, I was wondering whether you are interested in a program for Windows or Application for Android/iPhone for the same purpose you want for this Excel task. I believe that an application will be a better choice for you. If you are interested, I can start working on it to compete on this contest.

    • 1 тиждень тому
    1. hmmike
      Організатор конкурсу
      • 1 тиждень тому

      Program for Windows will be good a better option. when i generate this report, i generate this through excel in PC. so i think a Windows program is more appropriate.

      • 1 тиждень тому
  • alihyder128
    alihyder128
    • 1 тиждень тому

    Ok sir i understand I will prepare this sheet and upload it later. By creating a good trumpet.

    • 1 тиждень тому
  • navneetpatyal
    navneetpatyal
    • 1 тиждень тому

    sir what you want ?

    • 1 тиждень тому

Більше коментарів

Як організувати конкурс

  • Опублікуйте свій конкурс

    Опублікуйте свій конкурс Швидко та просто

  • Отримайте безліч конкурсних робіт

    Отримайте безліч конкурсних робіт З усього світу

  • Оберіть найкращу роботу

    Оберіть найкращу роботу Завантажуйте файли - це просто!

Опублікувати конкурс зараз або приєднуйтесь до нас вже сьогодні!