Overview of The J. P. Mueller Group Project Plan Template for Google Sheets

GET THE TEMPLATE AT http://www.jpmueller.com

I needed a Project Plan Template that worked in Google Sheets. While I found several, none of them provided the functionality I needed. So I built it myself!

The Template Interface
- Making your own copy
- Enabling Google scripts
- Release Notes (New Features and Bug Fixes)
- Backlog
- Entering project tasks
- Hidden rows & columns
- Don’t enter data in blue columns
- Show calculations
- Fixing Formulas
- Removing Previous Data

Your First Project
- Parent tasks
- Child tasks
- Configurable milestones symbol
- Completed task indications
- Past Due task indications
- Contextual Gantt Colors
- Gantt chart timeframe manipulations
- Today's date is highlighted
- Progress Sparkline Barcharts show % complete, % behind schedule, and % past due

Dependencies
- Linking to other tasks
- Dependencies on today’s date
- Dependent tasks to not start on a nonworking day

Calendaring Functionality
- Configurable working days
- Configurable Work Days per Week
- Configurable Work Days per Month
- Configurable Holiday Calendar

Gantt Chart Manipulations
- Changing Start Date
- Can start on current week
- Can start on previous week
- Configurable starting day of week
- Configurable Gantt Interval
- Can expand Gantt chart

Advanced Task Manipulation
- Indenting and Outdenting Tasks
- Rolling Up Tasks
- Ability to insert your own columns

Action Items
- Unique ID automatically generated
- Creating a new AI from currently selected PP task
- Supports standard Google Sheets data filtering
- Filtering based on currently selected PP task

Using your plan to collaborate
- Red & Yellow Risk and Due Status highlighting
- Supports Google Sheets Comments
- Supports Google Sheets Task Assignents
- Supports Google Sheets Notes

Localization
- Supports Google Sheets standard Locales configurations
- Supports international date formats
- Configurable column headings to local language

Видео Overview of The J. P. Mueller Group Project Plan Template for Google Sheets канала Jonathan Mueller