Simple GANTT Chart on Excell templates

[glenn59]

Hello
i am looking for someone to help create a project planner, the closest one i could find on the excel templates is the "simple Gantt Chart" or "Gantt project planner" in templates, with some modification in terms of extending the chart to be a yearly chart and showing the weeks, a mix of the two would be perfect.
if someone could contact me as i think this would be easier to explain if i show samples of what we need, its not something i'm expecting someone to do for free so would happily discuss a fee for your help.

Many Thanks

 

[etaf]

i have prduced a few gantt charts, privately and on the forums, and i'm happy to have a go on the forum, if you can be bothered to post all the details
BUT this is a free site - not sure if they have a payfor section - they have a consulting section

Consulting Services

Are you stuck doing a tedious manual process day after day? This can be automated using VBA macros behind your Excel worksheets. For over twenty years, these Excel consultants work with customers via e-mail or telephone to build a solution.

www.mrexcel.com

also its against the rules to take the info off line , as far as i know

• Rule #5:​

  Soliciting business for yourself is not permitted. This is an all volunteer board, so offering solutions in exchange for compensation is not permitted. Likewise, members seeking solutions must not offer compensation for them. If you have an urgent need, check the Consulting Services page.

i have most templates on dropbox a;; the time - so i could link here and use xl2bb

Plan Gnant-v2.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
4	Task	Description	Comment - Skills / People Required	Item Status	Start Date	Finish Date	Duration	17 Aug 15	24 Aug 15	31 Aug 15	07 Sep 15	14 Sep 15	21 Sep 15	28 Sep 15	05 Oct 15	12 Oct 15	19 Oct 15	26 Oct 15	02 Nov 15	09 Nov 15	16 Nov 15	23 Nov 15	30 Nov 15	07 Dec 15	14 Dec 15	21 Dec 15	28 Dec 15	04 Jan 16	11 Jan 16	18 Jan 16	25 Jan 16
5		Tender		Closed	8/20/15	9/12/15		1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
6	1	footings		Open	9/29/15	10/10/15		0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7	1.1	foundations		Open	10/11/15	10/30/15		0	0	0	0	0	0	0	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0
8	1.2	inspection		Open	MILESTONE	11/2/15													M
9	2	brick laying		Open	11/5/15	1/27/16		0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1
10	3	roofing Frame		Closed	12/19/15	1/28/16		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	1
11	3.1	roof slate/tiling		Open	1/28/16	1/29/16		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1
12	3.2	inspection		Open	MILESTONE	1/30/16																									M
Plan

Cell Formulas
Range	Formula
I4	I4	=MIN(F:F)-WEEKDAY(MIN(F:F),3)
J4:AF4	J4	=I4+7
I5:AF12	I5	=IF($F5="milestone", IF(AND(I$4<=$G5, J$4>$G5),"M",""), SUM((IF((I$4<$F5-MOD($F5-2,7)),0,IF((I$4>=$F5-MOD($F5-2,7)),1,0)))-(IF((I$4<$G5),0,IF((I$4>$G5),1,0)))))
F10	F10	=G10-40

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I5:AZ50	Expression	=AND(I5=1,$E5="closed")	text	YES
I4	Expression	=AND(TODAY()>=I4,TODAY()<J4)	text	YES
I4	Expression	=TODAY()>I4	text	YES
I5:AZ50	Expression	=AND(I5="M",$E5="open")	text	YES
I5:AZ50	Expression	=AND(I$4<TODAY(),I5=1)	text	YES
I5:AZ50	Cell Value	=1	text	YES
I5:AZ50	Cell Value	=0	text	YES
J4:AZ4	Expression	=AND(TODAY()>=J4,TODAY()<K4)	text	YES
J4:AZ4	Expression	=TODAY()>J4	text	YES

Cells with Data Validation
Cell	Allow	Criteria
E5:E12	List	Open, Closed

Gantt Chart Monthly.xlsx
	C							J			M				Q	R	S	T	U	V	W	X
1
2	Tasks							Status			Start Date				Expected completion	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23
3
4
5	Draft Plan							Complete			12-Dec-22				28-Feb-23
6	Consult Plan							In Progress			18-Mar-23				1-May-23
7	Finalise Plan							Not Commenced			1-May-23				14-May-23
8	Board Approval							Not Commenced			12-Jun-23				18-Jun-23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R5:X10	Expression	=AND((R$2>=$M5-(DAY($M5)-1)),R$2<=$Q5,$J5="Not Commenced")	text	YES
R5:X8	Expression	=AND((R$2>=$M5-(DAY($M5)-1)),R$2<=$Q5,$J5="in Progress")	text	YES
R5:X8	Expression	=AND((R$2>=$M5-(DAY($M5)-1)),R$2<=$Q5,$J5="complete")	text	YES

Gantt Chart Monthly.xlsx

Shared with Dropbox

www.dropbox.com

Gantt Plan Gnant-v2.xlsx

Shared with Dropbox

www.dropbox.com