Dear Mintra,
Firstly, in excel good pratice is, don't leave blank any row /column.
Which points you need to tracking?
What your business type?
Can you explain about your project site details, like in one day what type of activities done? (from start date to end date)
While going through your file, i notice that some of cell data not fulfill. (for example column "C" to "I".
If you need not any data within your sheet don't maintain.
Can you explain, what tracking you need? (As per your data maintain within sheet)
Try to maintain single data in single column. (In "Performance Period" you enter two dates) try to those in separate in two column.
Formatting of columns : All text data > format as "Genral", numeric number for as "Number", Date as "Date" format. etc. (Best way in date format select 14-Mar-01) dd-mmm=yy. (numeric alfa numeric)
Look at your "B" column : In this column you mention "FY2015 - Agencies", "FY2015 - Local Assistance", "FY2015- Internal Projects", "FY2014-S Agencies", "FY2014 - Local", "FY 2014 - Internal Projects". I will suggest you, you should insert two column as one is financial year & project. And your "B" column data (CAV, CAA, CAM) is vendor name (for header name just for example)
Look your data as "Last Perf Report" this is required only for "2015 Internal Report" & "2014 Internal Report". Kindly restructure.
Suggested Points for All Projects:
Data : Filling out the Data sheet completes the header portion of all remaining sheets in the project workbook.
Status : Status report that can be used to keep sponsors, team members, and stakeholders informed of project progress.
Budget : The Budget sheet allows you to track original budget, expenditures to date, and any cost variance.
Costing : The Cost/Benefit Analysis sheet allows you to review the proposed project and potential alternatives and make a project selection based on a greater ROI (return on investment).
Risks : The Risk Management Matrix sheet allows you to identify, qualify, quantify, and prioritize risks (events that might happen; the uncertainty of a project), create mitigation and contingency plans, and assign risks owners.
Special Issue : The Issues Log sheet allows you to identify and monitor project issues (unplanned events that have happened).
Action : The Action Items sheet allows you to track and monitor action items assigned to team members. Action items are tasks that must be done but are too insignificant from a time perspective to track in your project schedule.
Breakdown : The Work Breakdown Structure sheet includes the activities that must be completed during a project, the effort required, all relevant dates, and the resources assigned to do the work.
R&R : The Roles and Responsibilities sheet shows the primary role of team members, any deliverables in which they are involved, and the percentage of time they are expected to work on the project.
And so many other points cover as per business / project type.
