Excel Tracker alterations
Budget: £20 – £250 GBP
Basically I have received a tracker from our contractors and I want to adjust it so that we can use it ourselves. In principal its just a tracker to show the dates when a report (i-auditor) has been signed. I want to add more to the tracker and add more so its easier to use. The tracker has an overview of all 114 Structures. Down the left hand side you will see different colours, the different colours refer to strings (offshore term for row of structures) and on each string is a number of structures. Each table to the right is the details for the individual Structures. The dates you can see in the tables are when the contractor receives the signed report back from us but we as the client want to record (Date contractor sent to us, date we signed, date we sent back, name of person signing for contractor and name of client signing)
I would like to have charts so that when reports have been received from the contractor we put the date in the cell and we have a accumulative number of reports waiting for signature and also how many have been signed. We basically want to know the progress and what stage they're at.
I would also like another tab included which would be called ‘’issues’’ this will basically be a table where we can insert issues so the person signing a report can check prior to signing.
I would like to have charts so that when reports have been received from the contractor we put the date in the cell and we have a accumulative number of reports waiting for signature and also how many have been signed. We basically want to know the progress and what stage they're at.
I would also like another tab included which would be called ‘’issues’’ this will basically be a table where we can insert issues so the person signing a report can check prior to signing.