Embedded Files
#Open actions list #LOP #LOI #List of Open Points #List of Open Items #Project management #Timing #Gantt #Milestones #Deliverables #Minutes
LOP - List of Open Points - fundamental tool for any projects to manage open actions or issues from identification to completion
LOP - List of Open Points - fundamental tool for any projects to manage open actions or issues from identification to completion
LOP-LMO- User help.pptx
Download the user help >> Here
List of Open Points
List of Open Points
A LOP - List of Open Points - is a fundamental tool for any projects to manage open actions or issues from identification to completion.
LOP template is connected to Outlook
LOP template is connected to Outlook
The Owner of the LOP can export the tasks to Outlook or import last updates from Outlook to the LOP
LOP template is a ppt slides and files organizer
LOP template is a ppt slides and files organizer
A double click in "Powerpoint" or "Folder" columns creates automatically hyperlinks to a Ppt presentation or a specific folders linked to the task ID in the LOP.
LOP template creates your minutes
LOP template creates your minutes
A click on "Update" button creates automatically your weekly minutes, sorting out relevant items from the LOP by classifying them by :
Actions without Due date - Actions in late - Actions due this week or next week - New actions created - Actions discussed - Actions closed
LOP template embedges a Gantt timing tool
LOP template embedges a Gantt timing tool
Create Gantt timings, track and report progress vs. initial baseline
LOP template embedges a milestones and deliverables cockpit
LOP template embedges a milestones and deliverables cockpit
Reccord key milestones dates per function and sub functions and set the deliverables required
A LOP - List of Open Points - is a fundamental tool for any projects to manage open actions or issues from identification to completion.
Columns description
Columns description
ID -> ID of the action - Unique identification of a task by an ID number. set automatically while new task row is starting to be filled
Creation date -> Date of creation of a task in the list. Enter by double click to set date of the day
Subject /Origin -> Subject or origin of the tasks.
Part/Supplier -> Part or supplier assigned to the tasks.
Action-> where the task or action is described in details
Start Date -> Date of start of the task or the action . Enter by double click to set date of the day
Due Date -> When the action is due. Enter by double click to set date of the day. Reschedule and keep historic with ALT+ENTER separator between due dates
Comments -> track progress of the task or add comments here - Enter by double click to set prefix as date of the day automatically in the cell.
Revision Date -> date of last comments entered
Closing date -> date when task has been completed. Enter by double click to set date of the day
Status -> Set automatically according other cells inputs. Status can result in : "New", "Doing", "Done", "On-time?", "In-late", "Not started"
PowerPoint -> Enter by double click to create hyperlink and create specific section in the presentation selected ( to select in Link Menu)
Folder -> Enter by double click to create hyperlink and a specific sub-folder where to store deliverables linked to the task
Ergonomic functions included :
Ergonomic functions included :
Set Due date
Set Due date
Enter Due date and keep traceability of revisions by entering due dates separated by ALT+ENTER
Due date can be entered as date format or week number - macro will convert your entry in the format dd-mmm-yyyy or W##-yyyy
Last revised due date is in the last row and is considered to calulate the status of the task
Enter due date as a date or a week number
Enter due date as a date or a week number
52 is converted by macro to W52-2021
52 is converted by macro to W52-2021
Set Comments by entering with double click
Set Comments by entering with double click
Enter by double click will set automatically the date of the day - in blue - as a prefix of a new entry
Latest comments will be always set on top of the cell to stay visible
Status of items
Status of items
Set automatically by formula vs. other cells input
Status can be :NEW / NOT STARTED / DOING/ ON-TIME ? / IN LATE / DONE
Close items
Close items
Simply enter by double click in the "Closing date" column will result in closing the item + set date of the day
Download the user help >> Here
Mentions légales
The Files Market
RCS= 888 232 212 RCS Compiegne
N°Siren=888 232 212
N°Siret=888 232 212 00017
Google Sites
Report abuse