Dear planner;
Any body have experience to make Automatique Linear planning grapihc using Excel or AutoCAD?
Regards.
Linear project planning Excel/AutoCAD
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Ahmed,
This chart was produced automaticly from the netwok. What you need is the name, duration, start calcutated start and finih time, and start and finish location into any free numeric field. Of course if you want it to look nice, you have to define different styles, divide activities into different layers. This was produced by one of my students as a part of his BSc thesis in Construction Management.
Sorry I've tried, but this site do not accept pdf docs.
If you interested send me a mail to [email protected]
Miklos
Daniel,
Thank you for your comments its Realy hard to make make it on Excel and the constraint isn't to make at the first time , but to update it too.
Its Exist some software make That, but those software need complexe configuration of MSP or Primavera GANT , and I think its not verry interesting to buy expensive licences just to do Linear Schedule.
So if you have any templates on Excel be free to send it to me on [email protected]
Also, I have to receive ideas from planners on this subject.
Thank you on advance & regards.
Hi Eng.Ahmed,
You can do it in excel, but not entirely automatic. You need to design your chart, time and chainage and then you need export your major activities (including start and finish dates) in excel and use chart of excel to plot all the dates in various colored lines and then superimpose it in your time chainage chart. If are good in macro you can probably do it automatically.