Quick links. All shortcut keys for sheets
Embedded Files
Lets Grow the business together. Capture "qualified" leads and earn Rs 100/- per lead.
Project Advances Target: Advances to be approved immediately. Ensure that advances are within the project budget specified. Focus on getting the advanced transferred post approval. If delayed, escalate to auditor and director.
Pivo table showing name of the person and what is tha advance that is not transferred to him as of right now.
Large Projects Top Level Planning. (Projects) Target: Day wise planning for all resources to be done for overview plannning.
Site Weekly Schedule. Target: Define the weekly schedule with Minimum manpower to be used at site. Complete in minimum days. Complete with minimum budget. (as the sheet is very large and the latest tab keeps changing every week, it is not embedded here. Click and open the sheet)
Pivot table Showing manpower allocated to the site by date. (?)
All Projects Site Scope Definition. (Weekly Site) Target: Define the scope of site properly so that site team can see it and know what is to be done. Define the budgets for the site for on site resources and agencies to be engaged by site engineer directly. and Give special instructions for the site here.
Pivot table Showing sites where scope definition and other columns are left blank to be filled up.
Projects Sites Scheduled. (Weekly Site) Target: Make sure that sites are being done on time based on start and end dates planned.
Sites by type of job which are in scheduled stage in rows. Name of Engineer in Columns
Projects Sites On Hold. (Weekly Site) Target: Make sure that sites that are on hold are being exepedited and brought into scheduled status.
Sites by type of job which are in scheduled stage. Value of Jobs on Hold in the pivot table.
Large Projects Resource Planning. (Weekly Site) Target: Define the resources for the site based on tests and visual inspection to arrive at number of resources needed and number of days needed at the site.
Job wise resource allocation pivot table.
Projects Site Planning Tracking. (Projects) Target: Confirm that site planning, budget planning, site scheduling etc are are done
Pivot table to find the type of jobs and where the site planning and budgeting is not yet done.
Advances Planning. (Weekly Site) Target: Define the advances required to be transferred as per schedule to the team. So that the amount is known to them and agreed as per schedule of transfer
Pivot table of advances defined job wise, Jobs that are open status).
Documentation Planning. (Weekly Site) Target: Define the documents required for the site to get access etc.
Documentation required pivot table.
Travel Planning. (Weekly Site) Target: Define the outstation travel requirements here. So that booking can be done by Project Coordinator.
Travel planning pivot table. Travel is planned but tickets are not booked yet
Stay Planning. (Weekly Site) Target: Define the stay requirements here. So that booking can be done by Project Coordinator. If engineer is going to do the booking, mention it that way. So that start date and end date of stay are clear to everyone.
Stay planning pivot table. Travel is planned but tickets are not booked yet
Cover letters pending. Target: Get cover letters finalized without any gaps.
Pivot table of cover letters pending.
Task List. Target: Complete the tasks listed as soon as possible. escalate if stuck, resolve and finish
Rows with year and month from due date and priority within. Columns to have names of persons in the team
Training. List of training folders
Report abuse