I want to track actual productivity vs tendered productivity for two separate fields. Each of the fields represents two separate drilling scenarios, piloting occurs first in the process, followed by reaming The data for how many meters piloted and reamed is automatically sourced from each respective date tab. Once piloting has commenced, I would like to track against our tendered rates for piloting. The tendered rates can be seen in cell C3 of the "Actual Vs. Tender" tab.
Even if there is a day or two days where piloting doesn't take place due to a delay I would like the tendered rate to keep accumulating to track the overall progress. I would like the same tracking graph created for reaming meters.
In addition to this I would like to track our target mobilization & rig up times against our actual as well as tracking our demobilization and rig down times against our actual. From the tab "01.08" target days for the mobilization and demobilization are in cells O9 and O12 respectively. With the information for actual days coming from the table O1 to R6. I would like this information captured in the same worksheet as the Piloting and Reaming meters tracking.
I have over 15 yrs experience in IT and data processing. I have excellent knowledge in excel and word, I have very good communication skills - both written and oral. I am very confident that I will deliver a quality product and provide you great value for money.