Project management and deadline follow-up with a spreadsheet (TO COME BY END OCT. 2020)

Tags: Spreadsheets

Rating: ★ ★ ☆ ☆ ☆

The spreadsheet provides:- a timeline/Gantt chart allowing to follow-up deadlines on multiple time-related resources, with different categories- the definition of milestones which are relevant for each resource, for each class and for the r

FullView

Description

Description
The spreadsheet provides:

- a timeline/Gantt chart allowing to follow-up deadlines on multiple time-related resources, with different categories
- the definition of milestones which are relevant for each resource, for each class and for the responsible of each resource
- a semi-automatic notification by email, based on deadlines and the milestones and person involved directly by the resource, the category and in general, depending on the type of deadline/milestone
- the follow-up of the distributed allocation of these resources (e.g. projects, services, ...)

Other characteristics and features:

- definition of responsible people (supervisors, managers involved at different levels, ...) which should be warned of the different deadlines

- definition of the status of the resource
- confidentiality-prone. Since data may be sensitive (in the GDPR sense), the spreadsheet's features limit as much as possible the use of personal data, which is possible optionally

- timeline granularity in the template is a fortnight/half a month. Can be changed with a reasonable effort to other granularities, such as monthly or weekly, up to daily


Known issues

- scaling of number of resources (automatic changes in ranges, formulas, conditions, etc.)
- Ref. dropdown list: clean the resource type names

Identified possible enhancement features

"Expert system" proposing renewals: based on a ideal mix of types of resources targeted per service, with constraints (to be added to the extension), provide on time renewal proposals, according to different time scenarios (simulations).


Application domains

The initial intended main use of the extension is to track personnel contracts of different types, which are linked to different durations, deadlines, milestones (linked to renewals).

With some adaptation, the extension can be used partially (excluding some of the worksheets, which are used roughly as "modules") according to needs. This could apply to the management and follow-up of material resources (shared or not), project management, planning of activities, releases, etc.

Collaboration and disclaimer

The extension is provided with no warranty.
Contributions to:
- identify issues
- fix issues
- improve features
- add features

to the extension are weicome.

Other Extensions

Project management and deadline follow-up with a spreadsheet (TO COME BY END OCT. 2020)

The spreadsheet provides:- a timeline/Gantt chart allowing to follow-up deadlines on multiple time-related resources, with different categories- the definition of milestones which are relevant for each resource, for each class and for the r

★ 2

10-2020

Feedback

★ ★ ☆ ☆ ☆

Post your review

Reviews

  • Giraffe Oct 19, 2020, 12:40 PM (8 days ago)

    ★ ★ ☆ ☆ ☆

    This template looks awesome, although i'm kinda missing the option to download it.

    (The download button is nowhere to be found)

    • Barryl Oct 26, 2020, 7:21 PM (7 hours ago)

      Yes, I think its still in the works and not available yet

RSS feed for reviews on this page | RSS feed for all reviews