I have a spreadsheet that works quite well but I need some alterations made to make it work even better.
Currently there is a macro that enables a mathematical function to occur if selected. This effects a group of values - It is the "apply retention" check box. Please see file attached.
Currently this function only has effect on the "Contract stage of Work" table.
What I want to acheive is that when this check box is selected that it wall apply to the "Variations to Contract" table and the summary table at the top.
So here is How retention works, you will need to grasp this concept to be able to complete this task.....
Okay, so in my line of work I have what is called retention.
Retention is 5% of the contract value with held by the client until the end of the job.
Each claim I make against the job, I have to deduct 10% off the claim and repeat this until the retention sum total equals 5% of the contract value.
So at some stage throughout the job I stop deducting the retention because I have reached 5% of the contract value. This what the macro does currently and works perfectly.
So if a project is $100 then retention will be $5. The macro stops any more retention from being deducted from the table.
At the end of the project I can claim this retention back from the client. Basically he holds it as security until practical completion.
So I need someone to make this work for the Variation table and its associated summary table at the top of the spreadsheet.
I think this is a easy task for someone highly competent in VBA coding
This is an urgent request and will need to be completed asap as I need to make a claim tomorrow.
25 freelancere byder i gennemsnit $104 på dette job
Hi, I have got the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.
Hi there, I am a IT professional. I have experience on VB itself (coding and IDE) and VBA macros development for data operations in a spreadsheet. I can do the work with the required thing
Dear client, how have you been? I've read your project description carefully. It seems that this project suits me perfectly. How about discuss in chat? Waiting for your reply. Best regards.