Project Dashboard (In excel) for tracking various items in our multiple projects.

Job ID: 33309386

Budget: ₹12,500 – ₹37,500 INR

As an rough idea below are something we have in our mind and we are looking for someone who can provide a solution covering below requirements.

1. Project Dashboard:
a) Single sheet (or) software providing details of overview of multiple projects
b) For each project the following details should be there.

• Total Project Value.
• Total change order value.
• Total man days consumed in project (Internal)
• Total man days consumed in site (Field activity)
• Overall status of project ( In-terms of color).
• Total amount invoiced.
• Pending value to be invoiced.
• Invoice projection in current month.
• Engineering Status (Information to be come in % ).
• Procurement Status ((Information to be come in % ).
• FAT Status (Information to be come in %)
• Delivery status (Info should come in %)
Related categories: Data Processing Data Entry Excel Excel VBA Excel Macros