I am a project manager and would like to create a template to assist with tracking multiple homes being constructed against forecast program dates. We build groups of 10-50 homes per stage and need to track their progress throughout (using the actual ‘completion date’ data set). I need formulas to quickly display in the ‘lot tracker’ section the status of each stage. There is more detail in the spread sheet attached.
Please quote the following;
- ‘Lot tracker’ Data table to act similar to example below. (more detail in attachment)
- Gantt chart for forecast dates (second tab of attached template)
- Additional gantt chart for actual completed dates (where job is ongoing apply nominal day range to forecast completion)
- Auto populating Gantt chart based off information input on first tab
17 freelancers are bidding on average $146 for this job
Hey there, My name is Akibul and I was glad to see you are looking for an excel developer. I am planning to write vba code to combine the excel file you mentioned. Let's discuss to move forward. Thanks!!!!!
Hy I am Shravan Meena I have experience of doing data entry from last many years, last days I have done a data entry work and I took $50 for that and they are very satisfied with my work. you can trust me