On Friday 26 August 2005 03:03 pm, Adam Pearson wrote: I have 6 houses at this time. I do Shelving, Mirrors, Door Hardware, Bath Hardware, and Shower doors/Enclosures.. I just need to keep track of when the sheetrock is in, when they are painted and when the counter tops are in. and if there is a closing date. I would like to show a projected date on these few items. > Richard Barmann wrote: > >Is there a Template or can you advise me on how to keep track of several > >houses under construction, They are all at different phases of completion. > > Richard > > How many houses have you got to deal with? > > How do you assess how complete the houses are? Do you/are you able to > express it as a percentage? If so, then you could just list all the > houses in a column on Calc, then enter the percentage complete. > > If assessing % complete is not convenient, you could establish a > duration for each phase of each house's construction - eg: > > prepare site, underground services, lay foundations: 3 weeks; > floor: 1 week; > wall frames: 3 weeks > roof and roof cladding: order and deliver trusses, 8 weeks from > commencement; > roof cladding: 2 weeks > wall linings: 2 weeks > etc > etc > > Then use a spreadsheet to list the activities in the first column, give > each activity two rows, fill in the planned weeks like a bar/gantt chart > with a fill colour and use the second of each activity's rows to mark > actual progress. For example, use dark blue/light blue to show > planned/actual progress. > > You could set up each house on a separate sheet. > > If that's not clear, I can construct and send you a sample directly if > you want. > > Regards > > Adam > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]
-- Dick Barmann Web Master georgiatraildrivers.com barmannsbar.com
