Our company’s policy doesn’t allow me to upload any documents from workplace, but i can share how it is created. It is just your another spreadsheet.

We have these columns:
Priority, Department, Project ID, Status, Start Date, Finish Date, Subject Summary, Notes to Self.

In Priority, you define the projects prioties in any manner of system so it helps you with what to look at first. (Helps with deciding what to work on if you are juggling many projects)

In Department, it gives you ability to filter projects related to any department. Also you bridge it to respective folder so you can go right to department’s projects’ folders.

In Project ID, We have a system here that gives IDs to projects. So every project has an unique numeric name. It helps me with filtering the projects i work on, also i bridge them with projects’ folders. So I can revert to any finished project later on when a rework or improvement pops up without trying to find a hell dozen of folders.

In Status, It tells me where the project is in the waterfall. A for Analysis, T for test, F for finished. I also make it conditioned coloring so i can easily keep a track of what is where.

I guess Start Date and Finish Date is obvious..

In Subject Summary, I create a sentence that defines the project clearly without any mumbo jumbo.

In Notes to Self, I create a log based on date. After every task (Not job or phase) i fill up a memo. So when i return next day, i can continue right away without having to remember what i have done or what i have to do.

I hope this helps!

Best Regards,