pexels startup stock photos 7376 Project management, resource planning and deadline follow-up with a spreadsheet

Tags: Business Calc Presentations 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 type of resource an

FullView
Timline

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 type of resource and for the group the resources are associated to
- 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 automatic part is based on the mail merge function which integrates with Thunderbird use.
- 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 notified 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 (still  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

Application domains

The initial intended main use of the extension is to track personnel contracts of different types, which are linked to different duration, 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 various needs. This could apply to the management and follow-up of material resources (shared or not), project management, planning of activities, releases, etc.

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).


- Introduce cell names (for better readability/maintenance)

- introduce parameters/dropdowns in the Pers worksheet

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.

Please cite the source of this file.

Homepage: https://github.com/flosta23/PL

Repository: https://github.com/flosta23/PL/blob/main/PL01.ods

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • 0.1 Beta 6.4 Linux CC-BY

    Version 0.1 Beta

    Download

Other Extensions

Project management, resource planning and deadline follow-up with a spreadsheet

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 type of resource an

11-2020

Feedback

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

  • Giraffe Oct 19, 2020, 12:40 PM (7 months ago)

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

    (The download button is nowhere to be found)

    • Flosta Nov 2, 2020, 3:46 PM (6 months ago)

      Dear Giraffe,

      I updated the extension to include the link to the download last Friday, but I cannot have the update to go thru the CMS.

      I have created a new extension which hopefully will appear tomorrow.

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

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

      • Flosta Nov 2, 2020, 3:46 PM (6 months ago)

        Dear Barryl,

        Indeed I updated the extension to include the link to the download last Friday, but I cannot have the update to go thru the CMS.

        I have created a new extension which hopefully will appear tomorrow.

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