Create and modify a project planning schedule with WBS work breakdown and Gantt time chart in one sheet.
Fiche mise à jour le :16 avril 2024
Compatible avec :
1 M+
Présentation
ProjectSheet summarizes several aspects of project management in a spreadsheet, both textual and visual. The aspects which you need to manage depend on the type of project and on what you like to control, like end date, budget. You can add your own aspects as well.

In the free version of the add-on you create tasks with start and finish dates and keep track of the progress. The optional Pro version adds calculations for task duration, work hours, resources, costs and chaining of tasks. You can try the Pro version with a 10-days free trial. 

𝗪𝗕𝗦
The start of project planning is to decompose the project scope in a multi-level Work Breakdown Structure of tasks by indenting tasks, resulting in tasks and summary tasks. The summary tasks combine the information of its subtasks. Summary tasks can be collapsed/expanded for overview.

𝗟𝗶𝗻𝗸𝗶𝗻𝗴 𝘁𝗮𝘀𝗸𝘀 (𝗣𝗿𝗼)
Tasks can be executed in a sequential order by chaining them as a waterfall. The start and finish dates are (re)calculated taking task duration, weekends and holidays into account.

𝗚𝗮𝗻𝘁𝘁 𝗰𝗵𝗮𝗿𝘁
The Gantt chart shows the start and finish dates of a task as a bar against a time scale. The timescale can be changed in order to show the entire project or parts in more detail. Milestone tasks can be added to divide the project scope in phases with decision points in between.

𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 (𝗣𝗿𝗼)
Resources are shared between all tasks by assigning them as needed. The costs per (summary) task and work type resource are calculated based on the hourly rate of the resource and the work hours per task. The work hours can be linked to the duration of the task.

𝗣𝗿𝗼𝗴𝗿𝗲𝘀𝘀
When executing the project you track it by stating the progress percentage per task. The Gantt bar shows the progress visually. Options for progress indication give color alerts in text or Gantt chart for progress and delay.

𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗲𝘅𝗮𝗺𝗽𝗹𝗲 𝘃𝗶𝗱𝗲𝗼𝘀
See the YouTube video for the free WBS breakdown, Gantt chart and progress features and the ProjectSheet channel for Linking tasks and Assigning resources.
Informations supplémentaires
TarifsNon disponible
Développeur
Non-professionnel
Règles de confidentialité
Conditions d'utilisation
ProjectSheet planning vous demandera les autorisations ci-dessous. En savoir plus
ProjectSheet planning aura besoin d'accéder à votre compte Google
ProjectSheet planning pourra ainsi effectuer les actions suivantes :
Afficher et gérer les feuilles de calcul dans lesquelles cette application a été installée
Afficher et diffuser du contenu Web tiers dans les invites et les barres latérales au sein des applications Google
Vous connecter à un service externe
Autoriser l'exécution de cette application en votre absence
Afficher l'adresse e-mail principale associée à votre compte Google
Consulter vos informations personnelles, y compris celles que vous avez choisi de rendre disponibles publiquement
Avis
Langue :
Trier par :
Google ne vérifie pas les avis ni les notes. En savoir plus sur les avis
Profile Picture
Pedago Clown
11 février 2023
Impossible à mettre sur la feuille Bou!!!
Cet avis est-il utile ?
Oui
Non
Profile Picture
Un utilisateur de ProjectSheet planning
11 août 2016
I like it, but there seems to be a problem with calculating costs. Once you have a few levels the costs start to double up. I opened a ticket with the help system to see if they respond. Update: Support responded right away and explained that I was entering a resource for the upper level line, so this causes the system to calculate a total that is double. I removed the resource name for the total and the calculation is perfect. Thank you! The other problem with the lines marking through the work hours and costs is because I haven't not paid for a pro version yet.
Cet avis est-il utile ?
Oui
Non
Profile Picture
Srv007 Virtuel
26 février 2021
It's simple to use
Cet avis est-il utile ?
Oui
Non
Profile Picture
Un utilisateur de ProjectSheet planning
28 mars 2014
Looks good... but it should be indicated immediately that is a non-free product.
Cet avis est-il utile ?
Oui
Non
1-4 sur 4
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal