monitor work progress inside spreadsheet

**0ldfart** · 05-07-2009, 12:35 AM

Hi All,
I have been asked to make up a proposal in an excel spreadsheet
for routine maintenance on computer equipment - eg. vacuuming machine internals, checking BIOS settings, etc. and to include the ability to monitor progress and produce reports showing dates work was performed and who did it. But to be honest I don't have the first idea on how to put in the options to monitor the work progress or who did the work either, I have managed to do the basic spreadsheet but that is all. I have tried to find some info on how to do this but I don't really have any idea on what I am looking for, so I am hoping someone can help me out with this request....... so if you can a "Big Thank You" for your time and effort.

regards Oldfart

**mubashir aziz** · 05-07-2009, 01:38 AM

Attach sample file with some filled data which will be helpful for others to give suggestion / solution .......

**0ldfart** · 05-10-2009, 04:30 AM

Hi I think I have attached the file for someone to look at .... hope it worked okay

Thank you all again.

**JBeaucaire** · 05-10-2009, 04:36 AM

Ok, so what are you trying to automate? Your layout looks good.

**Tashi** · 04-24-2012, 04:51 AM

How about the monitoring of construction project progress by spreadsheet? For example how can we keep track of the quality control checklist as the project progress is increasing.

**Tashi** · 04-24-2012, 04:56 AM

Please can you help me....because my projects are scattered and have to control and manage over 3 different projects located at different sites. But my main office is attached with head office in the city. So I have difficulties in managing three different sites of different nature. I want to use google doc (spreadsheet to monitor) the progress of work.
For example, you can create two spreadsheet files. One is use for central control.Such as the quality checklist, Row is the item checklist, column is for the room number.
Then want to link one page to another pages. How can i do this? If anyone can help me, I shall be very grateful .....