Plan & Progress Tracker

Plan and Progress Tracker v 3.45 - 250  DEMO			= input location		© copyright 1999-2004  by 4aBetterBusiness, Inc. Northfield, Illinois  847-470-3513										Units  for Display			weeks	(days,weeks,months)				7/2/2000	<-this cell is a reference date for weekdays	© copyright 1999-2003  by 4abetterbusiness, Inc.  Northfield, Illinois   847-470-3513																					Use of this Software indicates your consent to be bound by the license terms included.
															Start Date for Display			9/15/2003	mm/dd/yy format				37878
		Name of Project:													Time periods to display			70	(for sliding window display)									(this color displayed when "days" selected as units for display indicates a weekend day)
		Date of Last Project Update:													End Date to display			01/09/05	( calculated )		false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	True	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false	false
		Date of This Report			3/15/2004	16-Mar-04	<==this cell calculates a "today" at the end of the month, for confiitonal formatting.								Want to track actuals?			yes	(yes, no)		(If you enter yes, dates provided will show on the Gantt chart.  If you enter no,  the "actual" dates are ignored)
	This is a fully-functional version of the Plan & Progress Tracker, but limited to 10 tasks.                                                                                                   4aBetterBusiness, Inc. 847-470-3513    www.4abetterbusiness.com/tracker.htm	Linked Info	First Actual Warning Level Percent Over Budget Orange	Second Actual Warning Level Percent Over Budget Red	Click Here to View Order Form, or Buy From our Secure Online Store	Planned	Planned	Actual	Actual	Visual Completion Guide.  For Completion % below range, cell is clear.  Within range, partially shaded.  Above range, black.						Progress Alert - Percent Complete vs. Elapsed Time Consumed		Planned	Click Here for an Important Note on Printing		09/14/03	09/21/03	09/28/03	10/05/03	10/12/03	10/19/03	10/26/03	11/02/03	11/09/03	11/16/03	11/23/03	11/30/03	12/07/03	12/14/03	12/21/03	12/28/03	01/04/04	01/11/04	01/18/04	01/25/04	02/01/04	02/08/04	02/15/04	02/22/04	02/29/04	03/07/04	03/14/04	03/21/04	03/28/04	04/04/04	04/11/04	04/18/04	04/25/04	05/02/04	05/09/04	05/16/04	05/23/04	05/30/04	06/06/04	06/13/04	06/20/04	06/27/04	07/04/04	07/11/04	07/18/04	07/25/04	08/01/04	08/08/04	08/15/04	08/22/04	08/29/04	09/05/04	09/12/04	09/19/04	09/26/04	10/03/04	10/10/04	10/17/04	10/24/04	10/31/04	11/07/04	11/14/04	11/21/04	11/28/04	12/05/04	12/12/04	12/19/04	12/26/04	01/02/05	01/09/05
	Start Using Now, or See Instructions and Tips for Use!		-10	20		Start	Completion	Start	Completion	Enter		Display				yellow %	10	Calendar		Up to today==>
Task	Description		Budget	Actual	Assigned to	Date	Date	Date	Date	%	0 -	21-	41-	61-	81-	red%	20	Days	Task Description		6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	-38362
						mm/dd/yy	mm/dd/yy	mm/dd/yy	mm/dd/yy	Compl	20	40	60	80	100	Consumed	Condition			Time Period	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70
1	Kickoff Meetings for Project Input		100	75	Maria	11/04/03	03/18/04	11/04/03		45						98%	RED	136	Kickoff Meetings for Project Input	Plan, Task 1								######	######	######	######	######	######	######	######	######	######	######	######	######	######	######	######	######	######	######	######																																														98%	98%
	Comments:																			Actual								37933	37940	37947	37954	37961	37968	37975	37982	37989	37996	38003	38010	38017	38024	38031	38038	38045	38052	38059	38066
2			100	95		12/15/03	03/15/04	12/20/03		100						100%		92		Plan, Task 2														######	######	######	######	######	######	######	######	######	######	######	######	######	######																																														100%	100%
	Comments:																			Actual														37975	37982	37989	37996	38003	38010	38017	38024	38031	38038	38045	38052	38059	38066
3			100	125						0								0		Plan, Task 3																																																																									0%	#DIV/0!
	Comments:																			Actual
4										0								0		Plan, Task 4																																																																									0%	#DIV/0!
	Comments:																			Actual
5										0								0		Plan, Task 5																																																																									0%	#DIV/0!
	Comments:																			Actual
6										0								0		Plan, Task 6