Excel Sample Sheet 41736 | Fresh Egg Time Tracker

Partial file snippet.

Sheet 1: Instructions

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		
 
		
		
	
		Fresh Egg Time Tracker - Instructions
		

		
	
		

		
	
		

		

		

		

		

		

		

		

		

		

		

		

		
	
		Thank you for downloading the Fresh Egg time tracker. We hope that you'll find the tool useful in identifying the drains on your time, helping you to focus on the right tasks. This tool has been designed to be very simple, using only basic Excel functions, allowing you to customise it to your specific requirements.
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Work Categories
		

		

	
	
		Firstly, in the Work Categories tab you'll see a list of 20 work categories. You shouldn't need more than this. As a team, categorise the different types of work that you do and try to standardise the categories across the team for ease of comparison.

Delete any categories you don't need. The time trackers will simply put blank entries in for these.
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cumulative Tracker
		

		

	
	
		The cumulative tracker will show how each work category changes over time, as well as the overall share of time given to a specific category cumulatively over a period of time. Use this to identify peaks and troughs in a category to enable better resource planning.

Combining the data from multiple time trackers will show the same data at a team level, allowing you to better understand where the team level time drains are and to assess the value of activities at both the individual and team level.
		

		

	



Sheet 2: Cumulative Tracker

	
	
	
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		
 
		
		

		

	
	
		

		Cumulative Time Tracker
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category
		Total Hours
		Total
		Share
		

		

		

		

		

		

		

		

	
	
		

		Jan
		Feb
		Mar
		Apr
		May
		Jun
		Jul
		Aug
		Sep
		Oct
		Nov
		Dec
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 1
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 2
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 3
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 4
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 5
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 6
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 7
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 8
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 9
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 10
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 11
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 12
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 13
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 14
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 15
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 16
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 17
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 18
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 19
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Work Category 20
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0.0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Total
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0%
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		
 
		
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		

 


Sheet 3: Example Time Tracker

	
	
	
	
	
	
	
	
	
	
		

		

		

		

		

		

		

		
 
		
		
	
		Time Tracker Template
		

		

		

		
	
		

		

		

		
	
		

		

		

		

		

		

		

		
	
		

		

		

		

		

		

		

		
	
		Name
		E.X. Ample
		

		

		

		

		

		
	
		

		

		

		

		

		

		

		

		

	
	
		Date
		Task Details
		Category
		Duration (hours)
		

		

		Categories
		Total Hours
		Share
	
	
		4/1/2019
		Client reports
		Analysis & Reporting
		4
		

		

		Analysis & Reporting
		5
		13%
	
	
		4/1/2019
		Breaks
		Breaks
		1.5
		

		

		Article Writing
		7.5
		19%
	
	
		4/1/2019
		Internal & client emails
		Responding To Emails
		1
		

		

		Breaks
		7
		18%
	
	
		4/1/2019
		Optimisation of X account
		Optimisation/Execution
		2
		

		

		Competitor Research
		6.5
		16%
	
	
		4/2/2019
		Conference - Y Event
		Conferences
		6
		

		

		Conferences
		6
		15%
	
	
		4/2/2019
		Travel to Y Event
		Travel
		2
		

		

		Consulting
		6
		15%
	
	
		4/3/2019
		On-site client consulting
		Consulting
		4
		

		

		Forecasting/Numerical Analysis
		0
		0%
	
	
		4/3/2019
		Travel to/from client
		Travel
		3
		

		

		General Research
		2
		5%
	
	
		4/3/2019
		Phone call with MD
		Meeting
		1
		

		

		Management
		0
		0%
	
	
		4/4/2019
		Reading industry news
		General Research
		2
		

		

		Meeting
		2.5
		6%
	
	
		4/4/2019
		Breaks
		Breaks
		1.75
		

		

		Miscellaneous
		1
		3%
	
	
		4/4/2019
		Revision for GAIQ exam
		Training
		2
		

		

		Optimisation/Execution
		4
		10%
	
	
		4/4/2019
		Internal & client emails
		Responding To Emails
		1
		

		

		Responding To Emails
		2
		5%
	
	
		4/4/2019
		Optimisation of X account
		Optimisation/Execution
		2
		

		

		Strategic Planning
		0
		0%
	
	
		4/5/2019
		Competitor research for ABC client
		Competitor Research
		6.5
		

		

		Time Off
		16
		40%
	
	
		4/5/2019
		Breaks
		Breaks
		1.25
		

		

		Training
		2
		5%
	
	
		4/5/2019
		Some general admin pieces
		Miscellaneous
		1
		

		

		Travel
		7.25
		18%
	
	
		4/8/2019
		Day off
		Time off
		8
		

		
 
		
		
	
		4/9/2019
		Day off
		Time off
		8
		

		
	
		4/10/2019
		Writing articles
		Article Writing
		7.5
		

		
	
		4/10/2019
		Breaks
		Breaks
		1
		

		
	
		4/11/2019
		Onsite consultancy for client 123
		Consulting
		2
		

		
	
		4/11/2019
		Travel to client 123
		Travel
		1
		

		
	
		4/11/2019
		Travel to client XYZ
		Travel
		1.25
		

		
	
		4/11/2019
		Monthly meeting with client 123
		Meeting
		1.5
		

		
	
		4/11/2019
		Breaks
		Breaks
		1.5
		

		
	
		4/11/2019
		Running numbers after client 123 meeting
		Analysis & Reporting
		1

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions fresh egg time tracker thank you for downloading the we hope that ll find tool useful in identifying drains on your helping to focus right tasks this has been designed be very simple using only basic excel functions allowing customise it specific requirements work categories firstly tab see a list of shouldn t need more than as team categorise different types do and try standardise across ease comparisondelete any don trackers will simply put blank entries these cumulative show how each category changes over well overall share given cumulatively period use identify peaks troughs enable better resource planningcombining data from multiple same at level understand where are assess value activities both individual total hours jan feb mar apr may jun jul aug sep oct nov dec example template name ex ample date task details duration client reports analysis amp reporting breaks article writing internal emails responding optimisation x account optimisationexecution competito...


Cumulative Time Tracker
Cumulative Time Tracker


Work Category	Total Hours												Total	Share
Work Category	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total	Share
Work Category 1	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 2	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 3	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 4	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 5	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 6	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 7	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 8	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 9	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 10	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 11	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 12	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 13	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 14	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 15	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 16	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 17	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 18	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 19	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Work Category 20	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%
Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0%

Related files

Share

Help


Time Tracker Template
Time Tracker Template


Name	E.X. Ample

Date	Task Details	Category	Duration (hours)	Categories	Total Hours	Share
4/1/2019	Client reports	Analysis & Reporting	4	Analysis & Reporting	5	13%
4/1/2019	Breaks	Breaks	1.5	Article Writing	7.5	19%
4/1/2019	Internal & client emails	Responding To Emails	1	Breaks	7	18%
4/1/2019	Optimisation of X account	Optimisation/Execution	2	Competitor Research	6.5	16%
4/2/2019	Conference - Y Event	Conferences	6	Conferences	6	15%
4/2/2019	Travel to Y Event	Travel	2	Consulting	6	15%
4/3/2019	On-site client consulting	Consulting	4	Forecasting/Numerical Analysis	0	0%
4/3/2019	Travel to/from client	Travel	3	General Research	2	5%
4/3/2019	Phone call with MD	Meeting	1	Management	0	0%
4/4/2019	Reading industry news	General Research	2	Meeting	2.5	6%
4/4/2019	Breaks	Breaks	1.75	Miscellaneous	1	3%
4/4/2019	Revision for GAIQ exam	Training	2	Optimisation/Execution	4	10%
4/4/2019	Internal & client emails	Responding To Emails	1	Responding To Emails	2	5%
4/4/2019	Optimisation of X account	Optimisation/Execution	2	Strategic Planning	0	0%
4/5/2019	Competitor research for ABC client	Competitor Research	6.5	Time Off	16	40%
4/5/2019	Breaks	Breaks	1.25	Training	2	5%
4/5/2019	Some general admin pieces	Miscellaneous	1	Travel	7.25	18%
4/8/2019	Day off	Time off	8
4/9/2019	Day off	Time off	8
4/10/2019	Writing articles	Article Writing	7.5
4/10/2019	Breaks	Breaks	1
4/11/2019	Onsite consultancy for client 123	Consulting	2
4/11/2019	Travel to client 123	Travel	1
4/11/2019	Travel to client XYZ	Travel	1.25
4/11/2019	Monthly meeting with client 123	Meeting	1.5
4/11/2019	Breaks	Breaks	1.5
4/11/2019	Running numbers after client 123 meeting	Analysis & Reporting	1

Related files

Share

Share to social media

Help

Login Area