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.
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 akherief2@gmail.com
Also, I have to receive ideas from planners on this subject.
Thank you on advance & regards.
Member for
24 years
Member for24 years
Submitted by Daniel Limson on Wed, 2011-05-04 12:07
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.
Member for
14 years 5 monthsAhmed,This chart was produced
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 hajdu.miklos@ybl.szie.hu
Miklos
Member for
14 years 11 monthsDaniel, Thank you for your
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 akherief2@gmail.com
Also, I have to receive ideas from planners on this subject.
Thank you on advance & regards.
Member for
24 yearsHi Eng.Ahmed, You can do it
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.